Using a variable in a userform label

[BigDubbe]

So basically what I want to do is in the body of the macro I have set x = 1 and I want to show that answer in a userform as label1. How would I go about referring to that variable.

I have tired:

UserForm1.Label1.Caption = x (and that doesnt work)

Any help would be awesome

Thanks

[dominicb]

Good afternoon BigDubbe

Your syntax is quite correct (assuming that your your form is called UserForm1 and your label is calledLabel1). That, and the fact that no error is being generated probably makes me think that you are setting a value to x in one event driven sub, and calling it in another. Put this line at the very top of your userform code, before any of the subs and see if it works. This will make the variable x available to all subs in the userform module :

Dim x as Long

HTH

DominicB

[BigDubbe]

I see what you are saying, but X is not being set in the userform. I have X being set in a different module. So I dont know how to refer to variables in that module.

I was messing around but couldnt get anything to work example of what I was trying:


UserForm1.Label1.Caption = Module1.X (Didnt work)

I hope this makes the question more clear.

[royUK]

If you are setting X in a module other than the userform it must be a Global Variable. In the module

Option Explicit
Public X As Long

Sub setX()
X = 1
UserForm1.Show
End Sub

In the UserForm

Option Explicit


Private Sub UserForm_Initialize()
On Error Resume Next
Me.Label1.Caption = X
On Error GoTo 0
End Sub

[BigDubbe]

Thank you after a little tweaking it is working.