Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop-Down Menu
Creating a drop-down menu. I alreadsy created the list and named per
procedures. I've done this in the past but having trouble this time. When I did the Data-Validation, I keep on getting an error: "the list source must be a delimited list". I do not know what this means? what am I doing wrong? pls help! thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop-Down Menu
A delimited list is one whose elements are separated by a 'delimiter' - typically a comma or a semicolon. If you are trying to type the allowable list elements into the data validation pop-up form (as opposed to using a range of cells that contain the list elements), use a comma as the delimiter. Hope this helps! -- jamescox ------------------------------------------------------------------------ jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113546 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop-Down Menu
Watch this 5 min video:
How to setup a data validation drop down list: http://youtube.com/watch?v=t2OsWJijrOM -- Biff Microsoft Excel MVP "Manny" wrote in message ... Creating a drop-down menu. I alreadsy created the list and named per procedures. I've done this in the past but having trouble this time. When I did the Data-Validation, I keep on getting an error: "the list source must be a delimited list". I do not know what this means? what am I doing wrong? pls help! thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down choice needs to lead to another drop down menu | Excel Discussion (Misc queries) | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions | |||
Drop Down Menu | Excel Discussion (Misc queries) |