View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ExcelMonkey ExcelMonkey is offline
external usenet poster
 
Posts: 553
Default 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