Hello Everyone,
I am looking for a solution to change the caption of a label based on two combo box values.
I have two combo boxes with names defined as Year & Month and one label as lbl1.
My condition would be if Year.Value = "" or Month.Value ="" then lbl1.Caption = ""
Else
lbl1.Caption = Year.Value & "-" & Month.Value
I have put this above code under UserForm Initialization(), but nothing happens when I select data on both combo boxes.
Really Appreciate your help on this.
Best Regards,
Shib
I am looking for a solution to change the caption of a label based on two combo box values.
I have two combo boxes with names defined as Year & Month and one label as lbl1.
My condition would be if Year.Value = "" or Month.Value ="" then lbl1.Caption = ""
Else
lbl1.Caption = Year.Value & "-" & Month.Value
I have put this above code under UserForm Initialization(), but nothing happens when I select data on both combo boxes.
Really Appreciate your help on this.
Best Regards,
Shib