PDA

View Full Version : Validation or User form??



joelle
03-22-2006, 06:48 PM
Hello Experts,

I create a drop-down box using "data validation" and it works okay.
However, users will see that its a drop-down until they click on that cell.
Well thats not so good.
Pls what is a workaround for that -- can I use a user form?
And pls how to create a user form with a visible arrow so people know that its a drop-down menu.

This is my 1st time with this kinda thing so I appreciate any light you can shed.

Nee

matthewspatrick
03-22-2006, 07:26 PM
Nee,

You can embed controls in the worksheet, but to be honest, I almost never do it and I discourage people from doing it. I much prefer just using Data Validation.

joelle
03-22-2006, 07:43 PM
Thank you Matt for the postback but ... I'm lost.
I know how to use validation but problem is the arrow does not display
until users click on the cell - so whats the reason to create the dropdown menu anymore?

Pls any other suggestion?

Thx,
Nee

matthewspatrick
03-23-2006, 05:31 AM
Nee, perhaps you could use text somewhere on your worksheet telling your users, "make your selection here". Then, when they alight on that cell, voila, the arrow appears.

joelle
03-23-2006, 09:04 AM
Hello Matt,
Maybe. But I have more than 7 or 8 dropdowns so there would be
label here and there -- but I guess for now I have to live with this.
Thanks,
Nee