View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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