RE: $$Excel-Macros$$ Check box to highlight Row if Checked

-Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Bob Sent: Friday, August 19, 2011 3:10 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Check box to highlight Row if Checked Please Help with code! If CheckBox1 is Checked

Re: $$Excel-Macros$$ Check box to highlight Row if Checked

Dear BOB, try it... Private Sub CheckBox1_Click() If Sheet1.CheckBox1.Value = True Then Sheet2.Activate Sheet2.Range("A2:B2").Select Else Sheet1.Activate End If End Sub On Fri, Aug 19, 2011 at 3:09 AM, Bob wrote: > Please Help with code! > If CheckBox1 is Checked then Highlight Sheet2

Re: $$Excel-Macros$$ Check box to highlight Row if Checked

try thihs Private Sub CheckBox1_Click() If CheckBox1.Value = True Then Range("A2:B2").Select If CheckBox1.Value = False Then Range("A1:B1").Select End Sub On Fri, Aug 19, 2011 at 3:09 AM, Bob wrote: > Please Help with code! > If CheckBox1 is Checked then Highlight Sheet2 Row 2 Column A & B > T

$$Excel-Macros$$ Check box to highlight Row if Checked

Please Help with code! If CheckBox1 is Checked then Highlight Sheet2 Row 2 Column A & B Thanks so much in advance!!! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : htt