ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   pull down menu in validation cell (https://www.excelbanter.com/excel-programming/363567-pull-down-menu-validation-cell.html)

bizbber

pull down menu in validation cell
 
How do I get the arrow to "always" be visible in a cell which has list
validation...instead of only when you select that cell?

Tom Ogilvy

pull down menu in validation cell
 
That isn't supported.

YOu could put a combobox over the cell and use that instead.

--
Regards,
Tom Ogilvy


"bizbber" wrote:

How do I get the arrow to "always" be visible in a cell which has list
validation...instead of only when you select that cell?


Dave Peterson

pull down menu in validation cell
 
I like to just give those cells a different shade of fill color.

bizbber wrote:

How do I get the arrow to "always" be visible in a cell which has list
validation...instead of only when you select that cell?


--

Dave Peterson

bizbber

pull down menu in validation cell
 
Thanks Tom, What is a combo box?

"Tom Ogilvy" wrote:

That isn't supported.

YOu could put a combobox over the cell and use that instead.

--
Regards,
Tom Ogilvy


"bizbber" wrote:

How do I get the arrow to "always" be visible in a cell which has list
validation...instead of only when you select that cell?


bizbber

pull down menu in validation cell
 
Thanks Dave. I'll try that too.

"Dave Peterson" wrote:

I like to just give those cells a different shade of fill color.

bizbber wrote:

How do I get the arrow to "always" be visible in a cell which has list
validation...instead of only when you select that cell?


--

Dave Peterson


Tom Ogilvy

pull down menu in validation cell
 
http://www.contextures.com/xlDataVal10.html

--
Regards,
Tom Ogilvy



"bizbber" wrote:

Thanks Tom, What is a combo box?

"Tom Ogilvy" wrote:

That isn't supported.

YOu could put a combobox over the cell and use that instead.

--
Regards,
Tom Ogilvy


"bizbber" wrote:

How do I get the arrow to "always" be visible in a cell which has list
validation...instead of only when you select that cell?



All times are GMT +1. The time now is 02:55 PM.

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