Thread: How to populate a label control using data from a spreadsheet

I have a program that is used as a client login (electronic sign-in sheet). The opening screen is a UserForm where the client enters their ID #. On this screen I also have a Label control that displaces important information to the client. The information being displayed in the Label changes regularly. I would like for the employee that maintains the login program to be able to update the Label information without going into the VBA code. I have a tab labeled "Variables" which currently contains information that I use to populate several Combo Box controls. Is there a way to populate the text on the Label using one of the cells on the "Variables" tab?

I thought this would be as simple as it is to populate the Combo Boxes, but so far I have not come up with the right code to do it. I have done several searches and have not found anything that has given me the answer I am needing. Any help will be greatly appreciated.

Hello boylejob,

Is there a way to populate the text on the Label using one of the cells on the "Variables" tab?

Yes. On your Sheet for variables, choose a cell,Say H12, which will populate the Label, and then use Code like the following sample:

If Sheets("Variables").Range("H12") <> "" Then
Userform1.Label2.Caption=Sheets("Variables").Range("H12").Value
Else: Userform1.Label2.Caption = " Whatever you want it to display"
End If

Winon,

Thank you very much. That worked perfectly. I had something similar coded, but obviously had something out of place because it was not working.

Hello boylejob,

You are welcome.

Please mark your thread as Solved.