Validation list in data entry form

S

Steve M

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.
 
B

Bob Phillips

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.
 
J

Jacob Skaria

Add a combobox from the toolbox and set the Rowsource prooperty to a cell
range.
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top