View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Userform handling

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