Hi,
You can set the Enabled property to True or False depending on whether
its relevant.
Some thing like this where the checkbox with tick is for Credit card stuff.
Private Sub CheckBox1_Click()
With CheckBox1
' credit card related
Label1.Enabled = .Value
TextBox1.Enabled = .Value
' cash related
Label2.Enabled = Not .Value
Label2.Enabled = Not .Value
End With
End Sub
Cheers
Andy
rodrigo wrote:
Hi all.
My question is, how can i set off a part of an userform if a checkbox is
set as true? the idea is that all other coices get "grey" and can't be
handled until the input of the relationed data is finished.
Exapmle: the checkbox should verify if a person pays cash or a credit
card. if he pays cash, the information about the credit card should'n be
available.
thx a lot,
rodrigo
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info