MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Check Box


Posted by Bryan on January 06, 2001 6:35 AM

I need to use a macro which clicks on a Check box. How do I do this? Creating a new macro and clicking on the check Box produces no code showing the Box has been clicked. Any help appreciated.


Posted by Ed on January 06, 2001 7:28 AM


Try this Code:

ActiveSheet.Shapes("Check Box 1").Select
With Selection
.Value = xlOn
End With

Posted by Bryan on January 06, 2001 8:26 AM

Thanks, this works perfectly!