How to run multiple macros on combobox list to go to the worksheet selected

Originally Posted by 6StringJazzer

Welcome to the Forum ACCT-003!

Thanks! :]

I suspect that your question is very easy to answer but your description is a bit muddled. Are you saying that your combobox has a list of worksheet names and you want to use that to select a worksheet to activate? That's easy. But all this talk about multiple macros for each worksheet and assigning a macro for a selected name is unclear.

No, my combo box is a list of doctor's names. For example, John Smith, and Katie Smith. If I were to select John Smith's name from the combobox, it will bring me to John Smith's worksheet of the workbook. However if I were to select Katie Smith, it will still bring me to John Smith's worksheet of the same workbook when I want it to go to directly Katie Smith's worksheet.

Mind you I have to create 40 names on the combobox, which I did. But to link them to the their macros to bring me to the exact worksheet is tougher.

It will be much easier to understand your problem if you provide your file. This allows us to see your data, layout, code (if there is any), much easier than describing it in several paragraphs. You still have to explain what you want, but it makes the whole process easier. If you are looking for formulas to produce a desired result, it helps if you create a mock-up of what you want the result to look like. And once we understand the problem, having your file will let us experiment with your data, formulas, and code, and possibly attach a file with a completed solution.

It's quite long and confidential since it's for the company I work for. I created it today, original. Can I forward it to you by email instead? I don't want to publicly send it to everyone.

To post a file, under the text box where you type your reply click the Go Advanced button. Then in the next screen look above the reply box and click the paper click icon. You will get a pop-up screen. Click Add then Select to select a file from your local drive, upload it, and then click Done to attach it. It will be displayed underneath your post text. (Alternatively as the last step you can click the Insert Inline button and a hyperlink to the file will be inserted directly into your post text in the spot where your cursor is set at the moment you click the button.)

I will make sure to rep you.

Place the code you have into a dummy workbook, and attach, or simply post trhe code only.

Posting the code would be helpful, as coreytroy suggests. You can post the code along, or you can attach the worksheet with all the data deleted.

If not, I would need to understand how to associate a doctor's name to a worksheet. If the user selects John Smith from the combobox, what is the name of the corresponding worksheet and how do you map the name to the worksheet?