data validation box arrow

's Computer Specifications

Excel 2002 SP3
Win XP HE

Hi,
On a data validation cell using the drop down list, is it possible to
retain the down arrow *always* visible--as opposed to being visible only
when clicking on cell?
Thanks.

's Computer Specifications

No, it is not possible if you use validation. You can use a combobox from
the control toolbox instead

--

Regards,

Peo Sjoblom

"stef" <(E-Mail Removed)> wrote in message
news:ONw$8bg%(E-Mail Removed)...
> Excel 2002 SP3
> Win XP HE
>
> Hi,
> On a data validation cell using the drop down list, is it possible to
> retain the down arrow *always* visible--as opposed to being visible only
> when clicking on cell?
> Thanks.

's Computer Specifications

Peo Sjoblom wrote:
> No, it is not possible if you use validation. You can use a combobox from
> the control toolbox instead
>
>
OK, thanks.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data Validation Arrow Color	morjayne	Microsoft Excel Worksheet Functions	2	16th Apr 2008 08:43 PM
Data validation dropdown arrow disappeared	=?Utf-8?B?RGFuIFMu?=	Microsoft Excel Misc	2	17th Apr 2007 03:46 PM
Data Validation -- using arrow keys	=?Utf-8?B?TWF0dGhld1RhcA==?=	Microsoft Excel Misc	5	14th Oct 2005 06:08 PM
data validation list arrow style	=?Utf-8?B?Sm9obiBEYXZpZXM=?=	Microsoft Excel Programming	1	29th Sep 2005 02:49 PM
Data Validation - Drop-down list - make arrow visible at all times	=?Utf-8?B?c3VwZXJnb2F0?=	Microsoft Excel Misc	3	19th Apr 2005 01:01 PM