Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation list in data entry form
Hi
I have a data validation list which I use in the spreadsheet for the user to select from the drop down. I would like the user to be able to user a data entry form instead of adding to the master sheet. Is there any way I can create a form for this that will use the validation list drop down. When I tried 'data' and 'form' it only has text boxes. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation list in data entry form
Unfortunately, that is just a very simple form.
If you want richer controls, you will need to build your own userform, add the controls, and use VBA to control it. -- HTH Bob "Steve M" wrote in message ... Hi I have a data validation list which I use in the spreadsheet for the user to select from the drop down. I would like the user to be able to user a data entry form instead of adding to the master sheet. Is there any way I can create a form for this that will use the validation list drop down. When I tried 'data' and 'form' it only has text boxes. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation list in data entry form
Add a combobox from the toolbox and set the Rowsource prooperty to a cell
range. -- Jacob (MVP - Excel) "Steve M" wrote: Hi I have a data validation list which I use in the spreadsheet for the user to select from the drop down. I would like the user to be able to user a data entry form instead of adding to the master sheet. Is there any way I can create a form for this that will use the validation list drop down. When I tried 'data' and 'form' it only has text boxes. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation list in data entry form
If you are new to VBA ; from workbook launch VBE using short-key Alt+F11.
From menu 'Insert' a 'UserForm' and check out the toolbox controls available... Also check out the topic 'Excel Data Entry Worksheet Form' by Dave Peterson which do not use a userform http://www.contextures.com/xlForm02.html -- Jacob (MVP - Excel) "Jacob Skaria" wrote: Add a combobox from the toolbox and set the Rowsource prooperty to a cell range. -- Jacob (MVP - Excel) "Steve M" wrote: Hi I have a data validation list which I use in the spreadsheet for the user to select from the drop down. I would like the user to be able to user a data entry form instead of adding to the master sheet. Is there any way I can create a form for this that will use the validation list drop down. When I tried 'data' and 'form' it only has text boxes. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation list in data entry form
Many thanks for the tip, I will defiantly have to go down this route.
"Bob Phillips" wrote: Unfortunately, that is just a very simple form. If you want richer controls, you will need to build your own userform, add the controls, and use VBA to control it. -- HTH Bob "Steve M" wrote in message ... Hi I have a data validation list which I use in the spreadsheet for the user to select from the drop down. I would like the user to be able to user a data entry form instead of adding to the master sheet. Is there any way I can create a form for this that will use the validation list drop down. When I tried 'data' and 'form' it only has text boxes. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation list form sheet | Excel Worksheet Functions | |||
Data Validation on Data Entry Form | Excel Discussion (Misc queries) | |||
Search for a specific entry in a long data validation list | Excel Discussion (Misc queries) | |||
Data Entry Form and List | Excel Discussion (Misc queries) | |||
Data entry form - Add to list | Excel Discussion (Misc queries) |