User form for selection

[Veeru106]

Hi,

I am looking for simple solution to select my particulat sheet using user form.

I know how we can do it by writting Macro and assigning a button to it.

But in this case i have many sheets and creating a button for each sheet is not feasible.

what i was thiking if we can create user form and create list....user will go to form and will select a sheet name....it will go to that sheet.

Please suggest something, if we can do it better way.

Thank you as always

 

[Veeru106]

just attaching one file....so Main sheet is where we give them option to go to user form and then other sheets will be the options we will used in user form...thank you

 

[Belleke]

Like this?

 

[Veeru106]

Yes it can serve my purpose but how to excute it in my original sheet...how you have assign Blade sheets in list box??

 

[Belleke]

Open your original sheet and my example, then Alt + F11 and just drag the userform from my example to your original file.
Add a button to the sheet Main to open the userform Done.
See your example
You can see the code is in the userform and in sheet Main

 

[Veeru106]

Belleke...i tried to do that i can see user form has been coped in my original file and then i have also create code in main sheet to show user form then i have created a button in main sheet and when i click on it ...it says no macro is available or it has been disabled...can you please check....attaching sample file..

One thing more....can we change sheets name as per our convience and add as many sheets we want and list box automatically pick it up...Right?

 

[Belleke]

See this example ActiveX button and your button.
For this:
One thing more....can we change sheets name as per our convience and add as many sheets we want and list box automatically pick it up...Right?
Yes

 

[Veeru106]

Got it.....Thanks for taking time out for this....Really appreciate it...

 

[Belleke]

Glad to help, have a nice day