Clear Check Boxes Without VBA

[Vampyre]

Hi, I have an autoshape , that im using as a button to clear the rest of my form. i want to use this to also clear 2 clusters of check boxes.

Im not very hot on vba and would really like to do it using a macro, any ideas ??

as simple as possible please

Cheers

 

[Vampyre]

Sorry , where do i put that ?

sorry very new

 

[RoryA]

In a new module in your workbook. Open the VB Editor (Alt+f11), then choose Insert-Module and paste that code in.

 

[Vampyre]

Hi ive added this one

Sub ResetFormsCheckBoxes()
Dim cb As CheckBox
For Each cb In ActiveSheet.CheckBoxes
cb.Value = False
Next cb
End Sub


but every time i click my 'clear' autoshape, it tells me no cells were found?

 

[RoryA]

My code wouldn't tell you anything either way, so it must be down to whatever else your shape is doing.

 

[Vampyre]

Hi

well currently it clears a set range of boxes also on my form. is this why its having this problem? and how do i rectify? how is it linking to the box from that code ?

 

[RoryA]

Since I don't have the faintest idea what else is happening in the workbook, or how, I can't really say. Do you have other code attached to that shape or to the checkboxes?

 

[Vampyre]

Hi

no other code attached to that shape , but the sheet itself, has code to make boxes mandatory and forward the form via e-mail. (however, this is attached to a command button and not to the same shape as the clearing of boxes)

Does that give to a better idea?

 

[RoryA]

Not really.
I would have to assume you have some event code and your checkboxes are linked to cells - so when you clear the checkboxes, you alter the linked cells and the event code responds.

 

[Vampyre]

Hi

no these check boxes are just visual indicators, they dont link to any information, they just allow selections.

i just want it so every time i hit 'clear' it clears the text boxes and check boxes and returns the form to original state.

 

[RoryA]

Then your 'Clear' shape should simply call whatever code it has now to clear the textboxes and then my code to clear the textboxes.