use data-validaion list with Data>Form ?

[durandal05]

Hi,
The built in excel data input form (one in the Data menu) is almost perfect for my purposes except that you cannot get a drop-down menu for validation purposes like it appears in the cell itself.

Is there anyway to have a drop-down on the data form? And if not, is there a way to customize this form through programming? Or perhaps a template somewhere on the web that does much the same thing (search for records and edit them)?
Any help much appreciated
Andrew

[davesexcel]

You would need to create your own UserForm.