ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Clear Checkbox (https://www.excelbanter.com/excel-discussion-misc-queries/236081-clear-checkbox.html)

John

Clear Checkbox
 
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 please?

Thanks
John

Jacob Skaria

Clear Checkbox
 
Use the Terminate event of Userform2 to uncheck the form1 checkbox

Private Sub UserForm_Terminate()

End Sub

If this post helps click Yes
---------------
Jacob Skaria


"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 please?

Thanks
John



All times are GMT +1. The time now is 07:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com