ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Drop Down Menus (https://www.excelbanter.com/excel-discussion-misc-queries/226811-drop-down-menus.html)

PAS

Drop Down Menus
 
I'm attempting to create drop down menus, but it keeps indicating that the
list source has to be a delimited list - I don't know what that means. HELP!!

PS

Gord Dibben

Drop Down Menus
 
If you are typing the items into the Data ValidationListsource dialog you
must enter them as such

cat,dog,rat,horse note the commas

Or you can use a range of cells like =$A$1:$A$10


Gord Dibben MS Excel MVP

On Mon, 6 Apr 2009 11:30:01 -0700, PAS
wrote:

I'm attempting to create drop down menus, but it keeps indicating that the
list source has to be a delimited list - I don't know what that means. HELP!!

PS




All times are GMT +1. The time now is 12:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com