How to Activate a Sheet from a ComboBox

This is going to seem like a very stupid question to everyone but I am so completely new to this. I cannot understand this code stuff. Is there is a list of codes that get me to where I want to be? For instance MsgBox = Message box will appear?

My question is as follows:
I have a large workbook with about 100 sheets, and each one is labled with a vendor name and it displays orders that I have with them in that sheet. I have created a combobox with all the vendor names. I want to select the vendor that I want to look at from the pulldown menu and then hit "go" and only that vendor's sheet pops up. I want this to happen rather than scroll through all the sheets to find a particular vendor. I got all the vendor names in there but I can't get the command box to understand that when I choose "vendor one" in the pull down menu and hit go, that I want to see on "vendor ones's" sheet.

Does this make sense?

Hello Amkey,

Welcome to the Forum!

The title of your post is important. It will help you get your question answered quickly and correctly. It also helps members and guests to find answers to their questions.

A better title would be "Activate a Sheet from a ComboBox ".

If you need helping in changing the title of your post let me know. Click here to send me a message.

Sincerely,
Leith Ross

Hello Amkey,

In accordance with the forum's rules, I am locking your post. You have had ample time to correct the title and have not done so. You will have to contact myself or another moderator to unlock your post, only after you have agreed to change your title.

Sincerely,
Leith Ross

Hello Amkey,

It would help to know which type of drop down you are using: cell Validation List, Forms ComboBox, or a Control ToolBox ComboBox. The code to return the value selected is different for all three.

Sincerely,
Leith Ross