Drop down menue show always

[needhelp2]

I have many drop down menu in my excel sheet.
I want that all these drop down menu buttons always show irrespective of selection of cell.
Please confirm me its solution.ASAP
Thanks in advance.

 

[Andrew Poulsom]

Sorry, that's not possible with data validation. You could use ComboBoxes instead:

http://www.jkp-ads.com/Articles/controls06.asp

 

[needhelp2]

Thanks for your advice.
Its really help full for me.
Tell me how i rate your post?

 

[Andrew Poulsom]

Thanks for your advice.
Its really help full for me.
Tell me how i rate your post?

There isn't really a way to rate my reply. A thankyou is fine.