| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
microsoft excel help dealing with data entry forms....please help
how do i create a list box in a data entry form for a specific field? is it
even possible |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
microsoft excel help dealing with data entry forms....please help
You can show a list of a specific range in a cell.
Hit Data-------Validation, select 'list' then highlight your source data. You will then get a drop down list in the cell listing the items in your range Cheers Tony On Dec 15, 9:11 am, KD wrote: how do i create a list box in a data entry form for a specific field? is it even possible |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
microsoft excel help dealing with data entry forms....please h
yes i have tried this already but the list box for the items i have choosen
don't show up in the data entry form. i want the list box to show in the data entry form also...how do i get that to happen? "bony_tony" wrote: You can show a list of a specific range in a cell. Hit Data-------Validation, select 'list' then highlight your source data. You will then get a drop down list in the cell listing the items in your range Cheers Tony On Dec 15, 9:11 am, KD wrote: how do i create a list box in a data entry form for a specific field? is it even possible |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
microsoft excel help dealing with data entry forms....please h
what is the data entry form?
KD wrote: yes i have tried this already but the list box for the items i have choosen don't show up in the data entry form. i want the list box to show in the data entry form also...how do i get that to happen? "bony_tony" wrote: You can show a list of a specific range in a cell. Hit Data-------Validation, select 'list' then highlight your source data. You will then get a drop down list in the cell listing the items in your range Cheers Tony On Dec 15, 9:11 am, KD wrote: how do i create a list box in a data entry form for a specific field? is it even possible |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Matching Button for MS Excel 2007 or later | Excel Worksheet Functions | |||
| consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Excel as Data Entry into Access Database | Excel Discussion (Misc queries) | |||
| create excel spreadsheet to display data from filled text forms | Excel Discussion (Misc queries) | |||
Linear Mode
