Populate a label caption from a cell reference

[colinitaylor]

Im really new to VBA and was wondering if it is possible for a label caption to be linked to a referenced cell?

All advice appreciated

 

[colinitaylor]

I am running it from Module1 and get a runtime 424 error message

Sub GetMatchFixtures()

'This will populate the Fixtures in the userform
Label1.Caption = Range("Match1")

End Sub

 

[Norie]

Why are you running it from there?

Any code to populate controls on a userform should probably be in the userform's Initialize event.

Private Sub UserForm_Initialize()
    Label1.Caption = Range("Match1")
End Sub

 

[colinitaylor]

Thanks Norie I am on the right tracks now. I think!

I was on an introduction to VBA course last week, I didn't really find it all that helpful so I am just attempting a mini project of my own with the assistance of the course notes, Excel VBA for dummies and of course some assistance from your good self

 

[Norie]

Colin

I recall your previous post, I think something to do with ToggleButtons?

Where they mentioned/taught on the course at all?