Fading non selected numbers in a form

[Bremser]

I'm creating an order form that shows the end user 3 different product
alternatives. They will choose the one the want by clicking a check box for
that option. I want to fade the product information for the 2 items not
selected. Any ideas?

Thanks!

Bremser

 

[dan dungan]

Are you adding the checkboxes to a user form?
Which version of Excel are you using?

 

[Bremser]

I'm using Excel 2003. The check boxes are already in the form. It is an
order form.

 

[dan dungan]

I don't have 2003. So I'm not sure how you should proceed.

 

[Dave Peterson]

If you mean a userform (inside the VBE), then maybe you could drop the
checkboxes and use 3 optionbuttons. You may not see the change in
shading/highlighting, but I would think most Windows users are familiar with
that look and feel.

If you mean a worksheet that looks like a userform, maybe you could use a linked
cell and conditional formatting that depends on those linked cells (if the
linked cell is true, then the text is black--else the text is gray???).