Load caption box on userform open

E

ExcelMonkey

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
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Firing Event in another user form 1
How do I set focus (and select text) on a text box on a modeless userform? 0
Set Userform label text if form is not loaded??? 3
Count Timer Pause and Stop button 0
Defining UserForm Caption from a Variable 0
How to enumerate buttons on user form 2
Assign range to userform labels and textboxes 0
Label Caption on Subform from Textbox Value on Main Form 2

Top