MrExcel Publishing
Your One Stop for Excel Tips & Solutions

chaning a checkbox value with a macro


Posted by Damien on June 24, 2001 7:34 PM

I need to know how to change the value of checkbox witha macro it can be done with a button's code but these are private subs anyone?


Posted by Dax on June 25, 2001 3:46 AM

You can only control a userform from an another macro if you show the userform as vbModeless. E.g. if you had a userform (userform1) with a single checkbox (chk) then insert a module and try this: -

Sub Frm()
UserForm1.Show vbModeless

UserForm1.chk.Value = True

'Wait 3 seconds
t = Timer
While Timer < t + 3
DoEvents
Wend

'Change the checkbox value to unchecked
UserForm1.chk.Value = False

End Sub

HTH,
Dax.