Common routine to handle a check box
 

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

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

Common routine to handle a check box
 

On Tue, 21 Feb 2006 at 00:16:21, Bob Phillips (Bob Phillips
) wrote:
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.

Thanks. I'd read about using Me from within the event on a checkbox,
but thought that referred to the object and not the whole userform

Many thanks
--
Mike

Common routine to handle a check box
 

Me generally refers to the containing object, so it is the Userform in
userform code module, the worksheet in that sheet code module, and the
workbook in ThisWorkbook.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Mike News" wrote in message
...
On Tue, 21 Feb 2006 at 00:16:21, Bob Phillips (Bob Phillips
) wrote:
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.

Thanks. I'd read about using Me from within the event on a checkbox,
but thought that referred to the object and not the whole userform

Many thanks
--
Mike