Dr. Grande, thank you for sharing this video. i will reference it when i come across the need to use this during potential research.
@gaminxden11
6 жыл бұрын
Dr. Todd Grande, thanks a lot to your video... it really helped.
@DrGrande
6 жыл бұрын
You're welcome!
@holyshipman
7 жыл бұрын
this works great although every time i click the button it duplicates the sheets can you suggest some code to prevent it from duplicating existing sheets?
@nayeembanu7478
7 жыл бұрын
Thanks Todd, I tried and Im half way through, however my code for the ComboBox is not working fine, its not actually taking me to respective worksheets, while writing the code I did not get to write this "ws.Select ... I dint get Select option at all"
@anastasiakrainyk1274
6 жыл бұрын
Hello Dr. Grande, Thank you for the video. I was wondering if i have a combobox in a user form and i have populated the combobox with sheet names, how do i get it to go to the sheet only when i click a 'Save and Continue" command button and exit the user form if i click on a "Cancel' Command button?
@ngashiineka9003
6 жыл бұрын
Thanks very much.do i need to save the code as a macro enabled file?
@tarayptuemond2319
6 жыл бұрын
Nghashi Eka Yes
@nilanjanjoshi9027
7 жыл бұрын
How can I get dropdown list without the command button?
@floppy1075
4 жыл бұрын
Select Worksheets with an ActiveX Combo Box Control using Excel c#,anyone know? please help me
@liyode
6 жыл бұрын
i have used ur above work its really help me to navigate easily in more then 100 sheets .i want to do some more work in it if you help me on this as i want to select sheet and enter some numbers on specific cell of selected sheet . pl help on this how can i add these number on selected sheet from combobox
@nayeembanu7478
7 жыл бұрын
Its working. .... Thanks alot :)
@dragos9310
7 жыл бұрын
when i close the excel file it doesn t save the code , only the buttons . what should i do
@DrGrande
7 жыл бұрын
Are you saving the Excel file as a macro-enabled workbook (.xlsm)?
@dragos9310
7 жыл бұрын
Todd Grande it works now . i tried to save it as macro bla bla..but i had to unmark something in the options meniu about privacy
Пікірлер: 15