View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Untick a Checkbox on a userform


Hi,

I imagine you have used the click event of the checkbox on userform1 to call
userform2 si simply set it to false immediatly after it is checked

Private Sub CheckBox1_Click()
CheckBox1 = False
UserForm2.Show
End Sub

Mike

"John" wrote:

Hi,

I have two useforms. Useform1 has a Checkbox which when ticked opens
Userform2. When Userform2 is closed i would like the tick in the Checkbox in
Userform1 to not be their. How would this be done and where would the code
go please?

Thanks
John