Open UserForm and show result from another sheet

[FryGirl]

I have a Userform which is activated with the double clicking of a specific column. All this is working, but what I need is to have TextBox2 reference a cell off of another sheet.

Not sure how to reference the other sheet. TextBox1 will show the current activecell contents on the activesheet, but TextBox2 should show the contents of what is on Shee2.

Private Sub UserForm_Activate()
    Me.TextBox1.ControlSource = ActiveCell.Parent.Name & "!" & ActiveCell.Address
    Me.TextBox2.ControlSource = ActiveCell.Offset(, 5).Parent.Name & "!" & ActiveCell.Offset(, 5).Address
End Sub

 

[Yongle]

Is this what you want
TextBox1 = active cell value (eg A1)
TextBox2 = same cell in other sheet offset 5 columns (= F1)

Private Sub UserForm_Activate()
    Dim cel As Range: Set cel = ActiveCell
    Me.TextBox1.Value = cel.Value
    Me.TextBox2.Value = Sheets("OtherSheetName").Range(cel.Address).Offset(, 5).Value
End Sub

 

[FryGirl]

Yes, thank you. This did the trick.