+ Reply to Thread
Results 1 to 5 of 5

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

  1. #1
    Registered User
    Join Date
    07-23-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    3

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

    [SOLVED]

    Hi everyone!

    I've been googling, and youtubing to find the answer to my question, but I can't seem to find it. So forgive me if this is already posted.

    I created a combobox with a list of names and create multiple macros for each worksheet in that workbook. When I assigned the macro for the selected name in the combo box, it will bring me to the selected name worksheet.

    However, when I selected a different name, it still brings me to the same worksheet instead of a different name worksheet. It happens again when I select whatever name and it still bring me to the same worksheet instead a different one each time.

    Is there a way to fix this? I don't want to create 100 buttons in order to run all the macros to bring me to the selected worksheet when I can select it from the combobox.

    I know there has to be a easier way. I just don't know how, and I try looking up in Microsoft Excel book but still can't find the answer.

    Thanks in advance!
    Last edited by ACCT-003; 07-24-2013 at 10:13 PM. Reason: Problem has been solved.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    20,540

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

    Welcome to the Forum ACCT-003!

    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.

    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.

    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.)
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    07-23-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    3

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

    Quote Originally Posted by 6StringJazzer View Post
    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.

  4. #4
    Forum Contributor
    Join Date
    01-02-2007
    Location
    Australia NSW
    MS-Off Ver
    2013
    Posts
    495

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

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

  5. #5
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    20,540

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

    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?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pre fill userform combobox depending on cell selected in worksheet
    By jjyoung in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-21-2013, 10:57 AM
  2. [SOLVED] Having trouble changing a combobox fill list with a macros
    By pheonix0 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-17-2012, 02:05 PM
  3. WorkSheet List Box Multiple Selection by Macros
    By karan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-05-2012, 01:35 AM
  4. Using same combobox with macros across multiple sheets
    By HMI in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-29-2011, 02:58 AM
  5. Userform Combobox value not returned when selected from drop-down list
    By asha3010 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-12-2010, 03:59 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1