+ Reply to Thread
Results 1 to 3 of 3

Creating a custom dropdown list without using code or cell reference

  1. #1
    Registered User
    Join Date
    08-05-2017
    Location
    UTC+07:00
    MS-Off Ver
    2016 64-bit on Win10 Pro 1703
    Posts
    66

    Creating a custom dropdown list without using code or cell reference

    I'm not sure where to post this, so please move it to the correct forum if necessary.

    I have a combo box in a worksheet, linked to the cell directly underneath it. I want only a few specific items in the dropdown list, like "running", "closed","pending." I hope to achieve this without using named ranges, cell references, or VBA code, and just type the list into a property box (ListFillRange maybe?).

    Can this be done? I remember stumbling upon an article somewhere about creating lists using separators, but couldn't find it any more.

    Appreciate your help.

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Creating a custom dropdown list without using code or cell reference

    You can do it with a data validation drop down, choose list and type in a comma delimited list

  3. #3
    Registered User
    Join Date
    08-05-2017
    Location
    UTC+07:00
    MS-Off Ver
    2016 64-bit on Win10 Pro 1703
    Posts
    66

    Thumbs up Re: Creating a custom dropdown list without using code or cell reference

    Damn, this is so ridiculously simple! I don't even need a combo box in the first place!
    Thanks a lot, Kyle, and sorry for the silly question.

+ 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. Reference output for all members of dropdown list in another cell
    By DrSues02 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-06-2017, 12:34 AM
  2. Creating a custom list to sort by cell color
    By zookeepertx in forum Excel General
    Replies: 4
    Last Post: 11-17-2014, 05:55 PM
  3. Dropdown list cell reference
    By AffreuxLex in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-04-2013, 06:22 PM
  4. Creating custom receipts with dropdown lists
    By mrskolbensvik in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-23-2013, 04:45 PM
  5. Creating dropdown list in custom toolbar.
    By ali84pk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-13-2011, 04:55 AM
  6. Replies: 1
    Last Post: 06-01-2011, 12:00 PM
  7. Replies: 2
    Last Post: 08-17-2007, 10:22 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