| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing label caption by user input
that fixed it. thnx1
"Tom Ogilvy" wrote: the obvious answer would be that the last item isn't exactly "4) Lowest" so it doesn't pass the test and take the action to update the label. there may be an extra space in there somewhere. -- Regards, Tom Ogilvy "juliejg1" wrote: I have a combo box that I have written code to change a labels caption depending on what the user selects from the combo list. it works right until the last item in the list is chosen...it doesn't change. This is the code that I am using If cmbSavType.Value = "1) Last Year" Then lblBase.Caption = "Prior:" ElseIf cmbSavType.Value = "2) Other Levels" Then lblBase.Caption = "Market:" ElseIf cmbSavType.Value = "3) Inflation" Then lblBase.Caption = "Inflated:" ElseIf cmbSavType.Value = "4) Lowest" Then lblBase.Caption = "Lowest:" End If |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing label caption in a Userform to an opterator value | Excel Programming | |||
| Label - Caption not changing | Excel Programming | |||
| Label - Caption not changing | Excel Programming | |||
| Changing Cell Contents Based Upon User Input | Excel Programming | |||
| changing the caption of a label | Excel Programming | |||
Threaded Mode
