Naviate to Worksheet/Activate Userform based on Cell Value

[applehugger]

I'm trying to create a friendly way for users to navigate through a workbook containing several worksheets.

In the attached workbook, on the Navigation worksheet, I have a combo box that will put text into B17 (which will be hidden eventually). I want the "Go" button to direct the user to a worksheet or userform based on the text in B17. For example, if the user selects "Create a clothing profile for a new resident," I need the Go button to bring up the ClothingUserForm. If the user selects "View or update the clothing profile for an existing resident," then it should activate the Updates workbook.

It's stumping me because I have friendly names and most solutions I can find rely on the text of the cell to match the name of a worksheet, and I also need this to activate a userform in addition to workbooks.

I really appreciate any help with this!

[PCI]

Here the list of actions you want to do.
What about the third one ?


Create a clothing profile for a new resident. => Launch USer form
View or update the clothing profile for an existing resident. => Go to sheet Updates
Query clothing profile data. => What to do ?

[applehugger]

Whoops sorry! "Query clothing profile data" will activate a worksheet that I haven't created yet.
Also, the list will grow. Except for "Create a clothing profile for a new resident," all of the other options will just need to activate a worksheet, so I can add that functionality later once I get a working framework.

[PCI]

See file attached, the Go button can be used later, just test and comment.

[applehugger]

Works perfectly! Thank you, PCI! I was debating whether to just use the Combobox to immediately direct the user to the appropriate userform/worksheet, but I think it will confuse users who select the wrong item from the dropdown, hence why I want to tie the action to the Go button.

[PCI]

it will confuse users who select the wrong item from the dropdown

Yes that makes sense
Perhaps you could use a validation menu for B17

See next code

Please Login or Register  to view this content.

[applehugger]

Yep, that does exactly what I want. Links the action to B17, which is based on the selection from the ComboBox. A very elegant solution! Thank you so much, PCI!

[PCI]

You're welcome and Thx again for the Rep.
Enjoy Excel ...!