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.


.