+ Reply to Thread
Results 1 to 2 of 2

How to make choices in a combo box from a macro?

  1. #1
    Registered User
    Join Date
    09-01-2010
    Location
    SoCal
    MS-Off Ver
    Excel 2010
    Posts
    62

    How to make choices in a combo box from a macro?

    Greetings all. I have a spreadsheet built by our IT folks that runs queries against our mainframe using 2 combo boxes as criteria.

    What I'd like to do is have a macro that selects, for instance, 10 different choices from these drop-down combo boxes, waits for the answer, then copy that answer elsewhere.

    I cannot find anything macro-wise that will allow me to click and enter data into these combo boxes.

    I can write macros for the copying etc. Our IT guys have a six-month backlog of changes so I can't wait for them. I do not understand their macros they have running behind the scenes. I do know the names of the combo boxes. Any help you can give me is much appreciated. Thank you!

  2. #2
    Registered User
    Join Date
    09-01-2010
    Location
    SoCal
    MS-Off Ver
    Excel 2010
    Posts
    62

    Re: How to make choices in a combo box from a macro?

    Ok, Fixed it. For those interested:

    Combo boxes have cell ranges defined for input selections and output (the chosen item).

    Have the macro throw in the chosen item(s) into the right cell (as defined by the combo box) and it acts the same as a mouse click.

    Repeat as necessary, problem solved!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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