Drop downs in Data Form

[Gator9]

Hi there,

I have been using the form option in the data menu to input info like a
database. One of my columns is uses validation with a dropdown menu.
Is there anyway to have that dropdown show up when inputting in forms?

 

[Debra Dalgleish]

You could try John Walkenbach's Enhanced Data Form. It's a free add-in
that allows combo boxes, so it could display a list of items.

http://j-walk.com/ss/dataform/index.htm

 

[Gator9]

tahnks this is great. One question. When using the original data form
I coul use my headings from any row. This seems to allow me only to us
the first row. Is there a way around that

 

[Dave Peterson]

If you leave an empty row before the header row, then it should work ok.

It looks like it uses the same range as you get when you do:
edit|goto|special|current region
(or ctrl-*)

 

[Dave Peterson]

Ps. If you want to customize it more, you can buy the password to the code for
$20 (USA).