Can an entry form have a drop down list?

[Tomtt]

Hello,
I have a very wide sheet with 26 columns. The best way to enter in new data is with the entry form because it is vertical. However, I would like that auto generated form to have drop down lists for the fields. Is that possible? I can set up a data verification for each column and the entry form will only allow me to enter in whatever is on the drop down list for each cell. But I would like that drop down list to be in the form itself.

Any solutions?

Thanks,
Tom

[BadlySpelledBuoy]

You can custom build a "UserForm" rather than use the built in option.

Takes a little more work, but is far more controllable.

BSB

[Tomtt]

Hi,
I would prefer doing that, even with the extra work. Can you point me in a direction? Are there any videos? I really want to avoid VBA. Tom

[BadlySpelledBuoy]

The two go hand in hand I'm afraid. A UserForm will do nothing without VBA.

What is your reason for wanting to avoid it?

BSB