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

DarkJester89

Board Regular
Joined
Nov 5, 2017
Messages
94
Office Version
  1. 2016
Platform
  1. Windows
VBA Code:
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

Board Regular
Joined
Nov 5, 2017
Messages
94
Office Version
  1. 2016
Platform
  1. Windows
I had to add calculate as the workbook is set to manual, but adding lablecaption as its own action worked. thank you!

VBA Code:
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.

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

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

GWteB

Well-known Member
Joined
Sep 10, 2010
Messages
1,295
Office Version
  1. 2013
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,126,999
Messages
5,622,115
Members
415,878
Latest member
jjj12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top