PDA

View Full Version : Solved: CheckBox Question



vzachin
11-03-2011, 07:43 AM
hi,

i have a Control Toolbox checkbox created.
i have this
Private Sub CheckBox1_Click()

If Checkbox1.Value = True Then
MsgBox "CheckBox1 is checked"
Else
MsgBox "CheckBox1 is unchecked"
End If

End Sub

how do i pass this value back into one of my modules?


thanks
zach

vzachin
11-03-2011, 08:39 AM
forgot to add a file

mancubus
11-03-2011, 08:51 AM
hi,


Sub Test()
If Sheet1.CheckBox1.Value = True Then
Call MyMacro1
End If
End Sub

vzachin
11-03-2011, 09:06 AM
thanks mancubus
i was so close

zach

mancubus
11-03-2011, 10:32 AM
you're wellcome.

if it's ok, pls mark the thread as solved from "thread tools."