Validation Dropdown List

Could someone please tell me if the re is a way to get the buttons on a
validation list to stay visible even if you do not have the cell
selected?

Thanks kindly for your help,

Steve

Use a combobox instead of data validation.

--
Regards,
Tom Ogilvy

"Smonczka" <[email protected]> wrote in message
news:[email protected]...
> Could someone please tell me if the re is a way to get the buttons on a
> validation list to stay visible even if you do not have the cell
> selected?
>
> Thanks kindly for your help,
>
> Steve
>

Steve

No. There is not a way.

Color the cell?

You could use a combo box in conjunction with the DV.

See Debra Dalgleish's site for more on this.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben Excel MVP

On 9 May 2005 13:02:26 -0700, "Smonczka" <[email protected]> wrote:

>Could someone please tell me if the re is a way to get the buttons on a
>validation list to stay visible even if you do not have the cell
>selected?
>
>Thanks kindly for your help,
>
>Steve

Gord Thank You! It worked wonderfuly. I used a Combo box and linked
to the cell just below it. Now when you change the combo box you end
up changing the data in the actual cell.

Thanks.

Steve