User Form Caption (Excel 2000)

Topic

New Reply

I am using Excel’s Visual Basic Editor to create a User Form and would like to add a variable to a Label caption. Is this possible? Something like: Your entry does not match the worksheet value of myVar is this correct?

In this case I would prefer the User Form to a Message Box.
Thanks

Reply | Quote

Replies

You can set the caption of a label in code, for example in the Initialize event of the userform.

Private Sub UserForm1_Initialize()
Me.Label1.Caption = “Your entry does not match ” & myVar & “. Is this correct?”
End Sub

or

Private Sub UserForm1_Initialize()
Me.Label1.Caption = “Your entry does not match ” & Worksheets(“Sheet1”).Range(“C37”).Value & “. Is this correct?”
End Sub

Reply | Quote

Thanks Hans that worked just perfect!

Reply | Quote

Yes, like this:

sStr=”And This Is A Variable Part Of The Caption”
Userform1.Caption=”This Is The Caption Of This Form ” & sStr

########edited: misread the question##############

Oh well, at least this shows you how to change the caption of the form itself

Reply | Quote