ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do I keep the dropdown list button visible continuously (https://www.excelbanter.com/excel-worksheet-functions/45392-how-do-i-keep-dropdown-list-button-visible-continuously.html)

dfinke

how do I keep the dropdown list button visible continuously
 
How do I keep the dropsown list "button" visible even when the cell
associated with the dropdown list is not selected?

Debra Dalgleish

Only the active cell can have the data validation arrow visible.
Perhaps you could colour the cells to highlight them, or add comments to
the cells to mark them.

dfinke wrote:
How do I keep the dropsown list "button" visible even when the cell
associated with the dropdown list is not selected?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


Cutter


Use a combo-box from the Forms toolbar?


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=467540



All times are GMT +1. The time now is 06:19 AM.

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