Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to show a drop down menu at all times

Status
Not open for further replies.
RyanScharfy

RyanScharfy

Technical User
Jun 17, 2003
86
US
I've validated a cell with a list of choices. Is there anyway to make it so the drop down menu is permanently visible, instead of visible only when clicking on the cell?

Thanks in advance
 
Sort by date Sort by votes



Hi,

Not with a Data/Validation.

However, you could use a ListBox from the Forms Toolbar.

Skip,

[glasses] [red][/red]
[tongue]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

pendle666
  • Locked
  • Question
Excel - Quick Access Toolbar - customise with a drop-down menu
Replies
3
Views
556
combo
combo
S
  • Locked
  • Question
MS Project - how to add a new task into an existing baseline
Replies
0
Views
274
selazar
S
duytoi
  • Locked
  • Question
How to add a head to the search results in Excel 2016 using VBA
Replies
2
Views
2K
Andrzejek
Andrzejek
ladyck3
  • Locked
  • Question
EXCEL - I'm starting a new project but have to say... to all...
Replies
2
Views
362
ladyck3
ladyck3
BugZap13
  • Locked
  • Question
Excel formula to count occurrences of a value in a different sheet
Replies
5
Views
978
bs6600
bs6600

Part and Inventory Search

Sponsor

Back
Top