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 wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

[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 use 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-*)



Gator9 wrote:
>
> 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 use
> the first row. Is there a way around that?
>
> --
> Gator9
> ------------------------------------------------------------------------
> Gator9's Profile: http://www.excelforum.com/member.php...o&userid=28752
> View this thread: http://www.excelforum.com/showthread...hreadid=484386

--

Dave Peterson

[Dave Peterson]

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



Gator9 wrote:
>
> 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 use
> the first row. Is there a way around that?
>
> --
> Gator9
> ------------------------------------------------------------------------
> Gator9's Profile: http://www.excelforum.com/member.php...o&userid=28752
> View this thread: http://www.excelforum.com/showthread...hreadid=484386

--

Dave Peterson