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?
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?
Peace of mind is found in some of the strangest places.
[VBA]
Dim cb As CheckBox
For Each cb In ActiveSheet.CheckBoxes
cb.Value = False
Next cb
[/VBA]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Knew it was something like that. Thanks
Peace of mind is found in some of the strangest places.
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??
Posting Permissions
Reply With Quote
