excel - Run macro (Private Sub) when checkbox is checked -

When the active cell is selected I have found the following macros to select the entire line. It's working perfectly! However, I'm just working on a checkbox "Check" when this macro wants to do the job

  Change the Private Sub Worksheet control (sub target as category) if target. Column & lt; & Gt; 1 again exit application. Screen updating = wrong cell Borders. Linesstyle = XLline StylingNow Rows (Target Rouge). Order around the order: = XLMidium, Colorindex: = 3 applications. Screen Updating = True and End and Low  

Depends on the name of the check box you have . But if checkboxie is 1 then you should work here

  if checkbox 1 Value = True then code otherwise: