Raani has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
How to show arrow on drop down list
Hi,
I've created a drop down list using data validation but unless the user is on the cell they won't know there's one there.
Can you tell me how to have the arrow showing when the cell isn't highlighted.
Thanks
Raani
RE: how to show arrow on drop down list
Hi Raani
Thanks for getting in touch. Unfortunately using Data Validation you can't have the arrow shown at all times.
If you must have that appearance, you can try using the combobox control, which is part of the Developer toolbar. It comes with a fair amount of work to display the result however. There's more information about it here:
http://www.meadinkent.co.uk/xldropdown.htm
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
