View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
juliejg1 juliejg1 is offline
external usenet poster
 
Posts: 81
Default changing label caption by user input

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