Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default drop-down button to remain visible

I want the drop down buttons I created to remain visible enve nwhen the
cursor is not located at their addresses. What should I do? The drop down
button only appear when the cursor arrives on the cell activated by the
button.
Thanks in advance
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 320
Default drop-down button to remain visible

If you must have a data validation type dropdown, then you're out of luck. If
you must have the arrow showing, use a combobox. You might consider
conditionally formatting the cell to be red when empty so that if not used
it'd be obvious that data is needed. To do that, color it red, and
conditionally color it white when the cell is empty (Len(A1)=0 if A1 is the
cell in question).
HTH

"Didier Rousselle" wrote:

I want the drop down buttons I created to remain visible enve nwhen the
cursor is not located at their addresses. What should I do? The drop down
button only appear when the cursor arrives on the cell activated by the
button.
Thanks in advance

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I make a drop down box visible within a worksheet? skittles_golf Excel Worksheet Functions 42 April 21st 23 02:59 PM
Filter drop-down is not visible Determined07 New Users to Excel 1 August 17th 07 04:03 AM
how do i make all choices in a drop down box visible taidoggy Excel Discussion (Misc queries) 1 October 11th 06 02:48 PM
Command Button Always Visible in window avveerkar Excel Discussion (Misc queries) 2 January 11th 06 12:21 PM
how do I keep the dropdown list button visible continuously dfinke Excel Worksheet Functions 2 September 14th 05 10:05 PM


All times are GMT +1. The time now is 11:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"