Clear checkboxes

[Guest]

Hi,

I have numerous check boxes in a worksheet that I would like to clear automatically by running a macro. I already have a macro set up to clear some other cells in my worksheet and I would like to add this function to my macro. I am not familiar with Visual Basic at all so if you could help me out with what to place where I would be most appreciative. Here is an example of my macro code:

Sub Clear()
'
' Clear Macro
' Macro recorded 11/26/2003 by Jamie Bourne
'
' Keyboard Shortcut: Ctrl+a
'
Range("M42").Select
Selection.ClearContents
Range("M43").Select
Selection.ClearContents
Range("B4").Select
End Sub

Any thoughts?

 

[Paul B]

Also posted, and answered, in Misc. Please do not post to multiple groups

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

Hi,

I have numerous check boxes in a worksheet that I would like to clear

automatically by running a macro. I already have a macro set up to clear
some other cells in my worksheet and I would like to add this function to my
macro. I am not familiar with Visual Basic at all so if you could help me
out with what to place where I would be most appreciative. Here is an
example of my macro code: