Making Label in UserForm = Cell.Value

[cicconmr]

I'm using the UserForm as an alert, and that alert will only appear when a certain cell equals a certain value.

What I'm wondering is if there is a way for the Label to be set to Cell.Value.

Matt

 

[VoG]

Try like this

Sub test()
UserForm1.Label1.Caption = Range("A1").Value
UserForm1.Show
End Sub

 

[marka87uk]

Label1.Caption = Range("A1").Value

 

[cicconmr]

So you can hard code UserForms with out actually using the interface that builds them?? It seems like if I add a label using the interface I can't control the caption...should I just put this code in a module?

 

[VoG]

The code that I posted goes in a regular module.

 

[cicconmr]

Okay thanks, I did not know I could do things that way...

I really appreciate the help! It's much easier just creating it in a module