+ Reply to Thread
Results 1 to 4 of 4

How to find the actual list of values that makes up a combo box.

  1. #1
    Registered User
    Join Date
    05-26-2013
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    79

    Question How to find the actual list of values that makes up a combo box.

    Hi All,

    I have a large work spreadsheet which has drop down lists for some cells. I need to modify or add to these lists but I cant find in this massive workbook where they are hidden. What is the easiest way to find the list of values and modify them.

    Surely really simple and something i havent found yet.

    Cheers,

    Spicey

  2. #2
    Registered User
    Join Date
    05-26-2013
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    79

    Re: How to find the actual list of values that makes up a combo box.

    Nevermind I found it. Data Validation under the Data Tab will give information for the source of the cell.

    Although it helps if someone hasn't hidden the list with white text!

  3. #3
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: How to find the actual list of values that makes up a combo box.

    Hello,

    if the drop-down lists are created with Data Validation (which is very likely), click on the cell, then click the Data ribbon and the "Data Validation" command.

    In the dialog that opens up, look at the formula in the "Source" field. If it contains a range like =Sheet1!$A$1:$A$10 that means that the list values are in Sheet 1, A1 to A10.

    If the field contains something like =Something that means that the list of values is calculated with a named formula. In that case, go to the Formulas ribbon, click the Name Manager icon and find the "Something" name in the list of defined names. The formula for the defined name may be a bit more complex than just a range of cells. Named formulas can be built to be dynamic and can use a variety of techniques that may involve formulas like Offset or Indes/Match combos.

    If you get lost, post what you have discovered. A sample file would be useful, too. Just make sure to replace confidential data like names with dummy text.

    cheers, teylyn

  4. #4
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: How to find the actual list of values that makes up a combo box.

    LOL, just read the comment you posted while I was composing my answer.

    Yes, if you inherit a workbook from someone else, you will get to curse a few times.

+ 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. Combo box will not give me an actual number
    By martijnvanderveldt in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-12-2014, 08:58 AM
  2. [SOLVED] Fill combo box list based on other combo box values
    By rain4uu in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-23-2013, 03:04 PM
  3. To find the values in the Combo box
    By abduljaleel.mca in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-02-2013, 05:41 AM
  4. Need VBA for Combo box and Data Validation list to find same value in another worksheet
    By jhudson321 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2012, 08:45 AM
  5. [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

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