Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have a userform with two checkboxes. One I have named Yes and one I have labeled No. This is my code in the No Event procedure UserForm2.Yes.Value = _ Not UserForm2.Yes.Value This is my code in the Yes event procedure UserForm2.No.Value = _ Not UserForm2.No.Value It works perfectly. The problem is that I want to add code to change the visibility of the textbox and label directly below it. When I try what I have below, it screws everything up and the checkboxes don't work correctly. This is what I have in each of the event procedures right above the above code I just displayed: Yes_Click Select Case UserForm2.Yes.Value Case Is = "True" UserForm2.SendToRepLabel.Visible = True Case Is = "False" UserForm2.SendToRepLabel.Visible = False End Select No_Click Select Case UserForm2.Yes.Value Case Is = "True" UserForm2.SendToRepLabel.Visible = True Case Is = "False" UserForm2.SendToRepLabel.Visible = False End Select Any ideas what this is doing that is screwing up my checkboxes? I mean, the select statements are not modifying the value of the checkboxes, so why would it screw with their behavior? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing the font for part of an axis label, not the whole label. | Charts and Charting in Excel | |||
Reference Label from TextBox | Excel Programming | |||
Help: Multiple Checkboxes (, naming and visibility) | Excel Programming | |||
Textbox text visibility | Excel Discussion (Misc queries) | |||
Changing the textbox value without changing the textbox format? | Excel Programming |