Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Something like
Private Sub CheckBox1_Click() With TextBox1 If Me.CheckBox1.Value Then .Enabled = True .BackColor = &HFFFFFF Else .Enabled = False .BackColor = 12632256 End If End With End Sub -- HTH RP (remove nothere from the email address if mailing direct) "rodrigo" wrote in message lkaboutsoftware.com... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error Handling | Excel Discussion (Misc queries) | |||
Access from add_in userform to main template userform.... | Excel Programming | |||
file handling | Excel Programming | |||
Error Handling | Excel Programming | |||
Error Handling | Excel Programming |