ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can I make the arrow on a List Box show all the time? (https://www.excelbanter.com/excel-programming/340791-can-i-make-arrow-list-box-show-all-time.html)

Linking to specific cells in pivot table

Can I make the arrow on a List Box show all the time?
 
Hi,

Hopefully this is a simple question - I want the drop down arrow on my list
box to appear at all times -- currently, it only appears when I click on the
cell which has the list box. Is there a way to have the arrow show at all
times? I created the List Box using Data - Validation.

Thanks!

Robert

Bob Phillips[_6_]

Can I make the arrow on a List Box show all the time?
 
Not that I know of. I tend to either use control toolbox comboboxes, or
shade those cells with a light colour so I know where they are.

--
HTH

Bob Phillips

"Linking to specific cells in pivot table"
crosoft.com wrote in
message ...
Hi,

Hopefully this is a simple question - I want the drop down arrow on my

list
box to appear at all times -- currently, it only appears when I click on

the
cell which has the list box. Is there a way to have the arrow show at all
times? I created the List Box using Data - Validation.

Thanks!

Robert





All times are GMT +1. The time now is 10:15 PM.

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