| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop down box problem
I want to do a simple data validation drop down box so
user can pick "X" or blank. I wan to put the "X" on a second hidden sheet in work book. The little box to set up validation list will not allow me to go to a separate work sheet to choose my LIST. what is up with that! Thank you Todd! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Drop down box problem
Hi Todd
try the following: - put your data on a second worksheet - define a name for this data range (goto 'Insert - Name - Define'). E.g. call this range 'data_list' - select your cell for which you want a drop down-list, goto 'Data - Validation - List' and enter the following as data source: =data_list -- Regards Frank Kabel Frankfurt, Germany Todd F wrote: I want to do a simple data validation drop down box so user can pick "X" or blank. I wan to put the "X" on a second hidden sheet in work book. The little box to set up validation list will not allow me to go to a separate work sheet to choose my LIST. what is up with that! Thank you Todd! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Drop down box problem
will keep in mind for other times but this time must have
it in same sheet to deploy to sales force. -----Original Message----- Hi Todd try the following: - put your data on a second worksheet - define a name for this data range (goto 'Insert - Name - Define'). E.g. call this range 'data_list' - select your cell for which you want a drop down-list, goto 'Data - Validation - List' and enter the following as data source: =data_list -- Regards Frank Kabel Frankfurt, Germany Todd F wrote: I want to do a simple data validation drop down box so user can pick "X" or blank. I wan to put the "X" on a second hidden sheet in work book. The little box to set up validation list will not allow me to go to a separate work sheet to choose my LIST. what is up with that! Thank you Todd! . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro nad drop down problem | Excel Discussion (Misc queries) | |||
| Drop Down List Problem | Excel Discussion (Misc queries) | |||
| Problem With Drop Down Box | Excel Discussion (Misc queries) | |||
| Drop Down Box problem | New Users to Excel | |||
| Drop Down Menus - 2nd Problem | Excel Worksheet Functions | |||
Hybrid Mode
