Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default 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?

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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?

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default 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?

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default 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


  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change cell contents when pull down menu choices change jb21 Excel Worksheet Functions 3 November 21st 08 10:34 PM
Pull Down Menu Bar JB in Kansas Excel Discussion (Misc queries) 2 May 30th 05 02:20 PM
How do I create a Calendar Drop Down menu for a Validation cell KC73 Excel Worksheet Functions 0 April 21st 05 10:15 PM
Data Validation or Pull Down Menu r wilcox Excel Programming 1 April 18th 05 11:54 PM
placing a pull-down menu at a cell location automatically Ken Nysse Excel Programming 4 October 4th 03 06:51 PM


All times are GMT +1. The time now is 05:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"