ActiveX Check Box Question

[Guest]

i am creating a form in excel 2002. i inserted an activex checkbox and i can change the true/false values in a linked cell but is there a way to change the pattern color of a group of cells when that box is checked. for example, if i check a box the color of cells b3 through g3 would turn green? any advice would be greatly appreciated.

 

[Tom Ogilvy]

Use conditional formatting - using the basis for change as the value in the
linked cell.

--
Regards,
Tom Ogilvy

i am creating a form in excel 2002. i inserted an activex checkbox and i

can change the true/false values in a linked cell but is there a way to
change the pattern color of a group of cells when that box is checked. for
example, if i check a box the color of cells b3 through g3 would turn green?
any advice would be greatly appreciated.

 

[Bob Phillips]

Hi Joseph,

If Checkbox1.Value = True Then
Range("B3:G3").interior.colorindex=10
Endif


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

i am creating a form in excel 2002. i inserted an activex checkbox and i

can change the true/false values in a linked cell but is there a way to
change the pattern color of a group of cells when that box is checked. for
example, if i check a box the color of cells b3 through g3 would turn green?
any advice would be greatly appreciated.

 

[Guest]

Thank you both ways worked