Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Label on User Form visible
I have what I think is an easy one, but I'm stuck.
I have a user form were the user is required to make selections in 3 fields, 2 comboboxes and 1 text box. I've placed a label above all three. The first one is set to visible.true, the other two set to visible.false. The first one has text: "Enter Origin First". When the user selects an item from combobox1, then set label1 to visible.false, and label2 visible.true and so on...kind of like having a bit of instruction as the user moves from one field to the next. I've tried code in the label something like: private sub label1_click() if combobox.text < "" then label1.visible = False End if Nothing happens tho, any suggestions? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COPY LABEL FORM FROM EXCEL TO A LABEL | New Users to Excel | |||
How to: User Form to assign a user defined range to a macro variab | Excel Programming | |||
Label Scroll Bar Properties: Make Visible? | Excel Programming | |||
Refresh label on user form with RefEdit | Excel Programming |