Can I use a combo box instead of a command button?

Hello, I have a big file with 45 sheets, and i created a Menu sheet, where I put Command buttons that send you to the needed sheet - however, I got the "subscript our of range" error, even if everything seems to be OK with the code line. Can it be because there are so many sheets in the file? The sheets can be put into 5 big categories - could I have instead of 45 command buttons just 5 combo boxes, from where the sheets can be selected?

can u upload a sample file so that i can understand properly what u want and i can help you.
Regards
CA Mahaveer Somani

Thank you for your quick replies. I have attached a sample file to this message, so that everything is clearer. thanks a lot.

Originally Posted by JosephP

if you have a subscript error it is most likely that one of the sheet names is incorrect. you could use comboboxes and use their change events to select the sheet

Thank you for your quick reply. Unfortunately this is not the reason for my error, I have checked and double checked the sheet names.

It would be too difficult to send the entire file, as there would be a lot of confidential data that i have to take out of it, to be able to show the error. My question was if I could use a combobox as shown in the sample file instead of the command buttons. In my big file i would have 45 command buttons, and that seems a little too much. Thank you again for your support.

what do you want with the 5 combobox? describe

When selecting one item in the combo box, I want to activate the respective sheet, just like the command buttons do now. Aside from the error, I got complaints that the big number of buttons was confusing

check the file and tell me do you want to do like this?

Regard
CA Mahaveer Somani

Yes, that is exactly how I want to do this. Basically, now i just have to adapt the code to my needs. Thank you very much for your help.

open my last attached file then press Alt+F11
there you will get my code.

if you required further help then tell me otherwise hit the solved thread....

Regards
CA Mahaveer Somani

Yes, I have seen the code, it's OK, I will mark this as solved.

thats nice...

glad to help you dear

Regards
CA Mahaveer Somani

Thanks for the help with the combo box yesterday, it worked, but not completely. Please find attached a sample of the whole file - see in the last combo box, Simulation Impact, only two of them work. I do not get any error message, they simply do not work. Do you have any idea what i might have done wrong?

check the attached file

then tell me if there is any another problem dear cosimna bereschiu

Regard
CA Mahaveer Somani

Now it works. I saw that the sheet names had a little issue with a space at the end of their name. Thanks for your help.

yes you got the major issue yourself........ha ha ha.....very nice dear....

Glad to Help You....

Regards
CA Mahaveer Somani