Common routine to handle a check box
Here is an example
Private Sub CommandButton1_Click()
blob Me.CheckBox1
End Sub
Private Sub blob(cb As MSForms.CheckBox)
MsgBox cb.Name
End Sub
This passes the object, not just one property, so you can access those
properties from within blob.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Mike News" wrote in message
...
I have a checkbox on a userform, and in a procedure I want to
make the checkbox invisible and
set it to false
Sub blob(x As CheckBox)
x.Visible = False
x = False
End Sub
So I have the above routine, but when am I calling it, how do I call
blob
blob(checkbox1) doesn't work because it's pass the value in I think
which is a boolean, and not of type checkbox
--
Mike
|