ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   drop-down button to remain visible (https://www.excelbanter.com/excel-discussion-misc-queries/170366-drop-down-button-remain-visible.html)

Didier Rousselle

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

Bob Umlas, Excel MVP

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



All times are GMT +1. The time now is 12:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com