How to auto-update label caption when it's look up changes?

[DarkJester89]

Private Sub ComboBox18_Change()
Dim Val As String

ThisWorkbook.Worksheets("User Dashboard").Range("L18").Value = Me.ComboBox18.Value
Label13.Caption = Sheets("User Dashboard").Range("K24").Text
Label13.Visible = True
End Sub

ComboBox18 starts off empty and Label is invisible

I make a selection in ComboBox1, Combox2 and Combox3, and final selection in ComboBox18, Label text becomes visible.

Adjustments to ComboBox1, Combox2 and Combox3 should update Label13 on change.

Any assistance would be much appreciated!

 

[DarkJester89]

I had to add calculate as the workbook is set to manual, but adding lablecaption as its own action worked. thank you!

Sub LabelCaptionUpdate()
    Label13.Caption = Sheets("User Dashboard").Range("K24").Text
    Label13.Visible = True
End Sub

Turning this into a sub, and calling it in other places worked, had assistance elsewhere.

Sub LabelCaptionUpdate() 
Calculate 
Label13.Caption = Sheets("User Dashboard").Range("K24").Text 
Label13.Visible = True 
End Sub –

 

[GWteB]

As I said in my post #6

make sure that the worksheet is recalculated on changes.

Glad it's sorted now and thanks for letting us know.