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" wrote in message
oups.com...
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" 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