![]() |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 02:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com