PDA

View Full Version : Solved: Clear check box on open



austenr
10-25-2005, 01:02 PM
I have done this be for but have lost the code. I want to clear the contents of the check boxes in my worksheet on open but using
Range("A1:A4").ClearContents does not work. In fact I have tried ClearAll and it does not either. Any ideas? :dunno

Bob Phillips
10-25-2005, 01:20 PM
Dim cb As CheckBox
For Each cb In ActiveSheet.CheckBoxes
cb.Value = False
Next cb

austenr
10-25-2005, 01:30 PM
Knew it was something like that. Thanks

alimcpill
10-26-2005, 08:52 AM
what's goin on here? if i type activesheet.Checkboxes in my immediate window, then highlight 'Checkboxes' and press F1, I received the following message:

Hidden Language Element

You have requested Help for a language element that is hidden, and therefore unavailable for programmatic access.

Have you been dabbling with the occult??