ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Validation List arrow visibility (https://www.excelbanter.com/excel-programming/394715-validation-list-arrow-visibility.html)

robs3131

Validation List arrow visibility
 
Hi all,

Is there a way to have the arrows for validation lists be made to be always
visible? The arrow is only visible if a user clicks on the validation cell.

Thanks!

--
Robert

Roger Govier[_3_]

Validation List arrow visibility
 
Hi

That is the behaviour with Data Validation, the dropdown only appears in the
Active cell.
Debra Dalgleish has information on her site and suggested workarounds.

http://www.contextures.com/xlDataVal08.html#Freeze

--
Regards
Roger Govier



"robs3131" wrote in message
...
Hi all,

Is there a way to have the arrows for validation lists be made to be
always
visible? The arrow is only visible if a user clicks on the validation
cell.

Thanks!

--
Robert




robs3131

Validation List arrow visibility
 
Thanks!

--
Robert


"Roger Govier" wrote:

Hi

That is the behaviour with Data Validation, the dropdown only appears in the
Active cell.
Debra Dalgleish has information on her site and suggested workarounds.

http://www.contextures.com/xlDataVal08.html#Freeze

--
Regards
Roger Govier



"robs3131" wrote in message
...
Hi all,

Is there a way to have the arrows for validation lists be made to be
always
visible? The arrow is only visible if a user clicks on the validation
cell.

Thanks!

--
Robert






All times are GMT +1. The time now is 07:48 PM.

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