I saw it a few secs after posting my reply...
It sure does the scrolling, now I have to adjust the code to have the sheets shown in the listbox, no big deal...
Thank you all guys!![]()
I saw it a few secs after posting my reply...
It sure does the scrolling, now I have to adjust the code to have the sheets shown in the listbox, no big deal...
Thank you all guys!![]()
Keep in mind all vba I know has been googled...
Dear all thank you for making my life easier and assisting me with any issues that I had...
I am posting a link to a rar file containing the bas and frm modules, that I have exported from the add-on I am compiling, in order to share them with you as a result of my appreciation to all the help provided.
The form will show all the visible sheets in the spreadsheet, highlight the current one that is active and will scroll with mouse wheel while the mouse is over the form. By double clicking any item the respective sheet is activated.
I am also attaching a screenshot in order to be more specific.
Screenshot.PNG
For Office 2013 users this is not needed actually since this functionality is already embedded and the form actually mimics it...
In order to download GO HERE
Keep in mind all vba I know has been googled...
Bookmarks