Data Entry Form and drop down lists

[AnneFr]

Hi All

I have created a worksheet with lovely drop down lists to keep my data accurate and I would like to make a data entry form for my users, to make it easier for them.

Whilst the automatic data sheet that Excel very kindly created automatically for me restricts the data that can be input (to choices that I have set up through data validation, dates, lists etc), I am unable to add the dropdown menu to the form, so that they know what the choice is...

Any suggestions anyone please?

I can see that I could create a whole new data form through VBA and ActiveX, but that seems a whole lot fo work and it looks very complicated for a non-VB user

Thansk everso

Anne

[Pepe Le Mokko]

Perhaps have a look at this link