Load caption box on userform open
 

I have a userform. I am trying to load a cell address into a caption box
when the form opens up. I am trying to do so by doing the following:

Private Sub UserForm3_Initialize()
UserForm1.Label1.Caption = ActiveCell.Parent.Name & ActiveCell.Address
End Sub

However this is not working. Am I using the wrong event?

Thanks

EM

Load caption box on userform open
 

Why are you trying to get a value from form1 in form3? If that were correct,
form1 would need to be loaded, is it?

Private Sub UserForm3_Initialize()
UserForm1.Label1.Caption = ActiveCell.Address(,,,True)
End Sub

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"ExcelMonkey" wrote in message
...
I have a userform. I am trying to load a cell address into a caption box
when the form opens up. I am trying to do so by doing the following:

Private Sub UserForm3_Initialize()
UserForm1.Label1.Caption = ActiveCell.Parent.Name & ActiveCell.Address
End Sub

However this is not working. Am I using the wrong event?

Thanks

EM