ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   microsoft excel help dealing with data entry forms....please help (https://www.excelbanter.com/excel-worksheet-functions/122742-microsoft-excel-help-dealing-data-entry-forms-please-help.html)

KD

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

bony_tony

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



KD

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




bony_tony

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