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???).

Bremser wrote:

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

--

Dave Peterson