+ Reply to Thread
Results 1 to 7 of 7

Populate active x combo box to multiple cells

  1. #1
    Registered User
    Join Date
    11-30-2013
    Location
    atlanta
    MS-Off Ver
    Excel 2007
    Posts
    3

    Post Populate active x combo box to multiple cells

    Is there an easy way to populate an active x combo box so that it works throughout a worksheet without having to create a combo box in each cell?

    Thank you!

    Barbara

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,450

    Re: Populate active x combo box to multiple cells

    Hi Barbara is that the same combobox? same items?

  3. #3
    Registered User
    Join Date
    11-30-2013
    Location
    atlanta
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Populate active x combo box to multiple cells

    Yes, it is the same combo box just placed in a different cell

  4. #4
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Populate active x combo box to multiple cells

    I would suggest to use Data Validation list for this as it can be easily copied down or across preserving the same settings.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  5. #5
    Registered User
    Join Date
    01-21-2012
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    41

    Smile Re: Populate active x combo box to multiple cells

    I agree with AlKey. Drop-down list could solve your problem.

    This link can help you: drop-down list tutorial

    Is it you are looking for?

  6. #6
    Registered User
    Join Date
    11-30-2013
    Location
    atlanta
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Populate active x combo box to multiple cells

    I am not sure that validation will work given what I need. I have 2 columns. One column is an identifier column and one has the information that I want input into the cell. As an example, column 1 contains a list of ingredients. Column 2 contains the cost per ounce of the ingredients. I want to be able to select the ingredient and have it input the cost. Is this possible with validation?

    Thank you!

  7. #7
    Valued Forum Contributor
    Join Date
    09-07-2006
    Posts
    520

    Re: Populate active x combo box to multiple cells

    Yes, if you have data validation lists** for ingredient selections running in A2 down
    you could use eg an Index/Match to retrieve the cost per ounce in the adjacent col B
    Eg in B2, copied down: =IF(A2="","",INDEX(Sheet1!B:B,MATCH(A2,Sheet1!A:A,0)))
    where Sheet1 contains the master reference data:
    - Ingredient data in col A, Cost per ounce data in col B

    **DVs can easily be propagated via copying down, or copy > paste
    --------------------------------------------------------------
    Any good? Wave it, hit the little star at the bottom left of my responses

+ 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. [SOLVED] Populate selected cells from combo box selection
    By Bravo33 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-12-2013, 03:09 AM
  2. Populate a textbox in a userform using multiple selections from a combo box
    By kksf in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-23-2013, 10:59 AM
  3. Combobox populate from cells (active X)
    By Gaz_m2k5 in forum Excel General
    Replies: 0
    Last Post: 06-21-2012, 12:13 PM
  4. [SOLVED] Find Row from Combo Box List Drop Down, auto populate Other Cells
    By debson in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-23-2012, 05:04 AM
  5. Multiple Dynamic Active X Combo Boxes.....Please HELP.....
    By VB@N3wb|3 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-09-2011, 05:52 PM

Tags for this Thread

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