How to extract the first range from a refedit selection

[Pookiemeister]

I am using the refedit control on my userform. Is there a way to extract the first range from my selection so I can offset it to retrieve other data from that row as well from "Sheet1" within workbook named "SDPF". Example: With the refedit, I am selecting the range(H1044:H1061). However, to extract the other pieces of data I just need the first selection, of H1044, so I can offset it to retrieve other data, in this case from Range(B1044), Range(C1044), Range(E1044), Range(F1044), and Range(I1044). Thank You

 

[Kenneth Hobson]

Private Sub CommandButton1_Click()
  Dim r As Range, r1 As Range
  Set r = Range(RefEdit1)
  Set r1 = r(1)
  MsgBox r1.Address, , r1.Address(external:=True)
End Sub

 

[Pookiemeister]

Thank you for the quick response. One question, instead of a message box how can I display the range in a textbox. I've tried:

Private Sub cmdbtnDone_Click()    Dim r As Range, r1 As Range
  Set r = Range(RefEdit1)
  Set r1 = r(1)
  textbox1.Value= (r1.Address, , r1.Address(external:=True))
End Sub

But I got a "Compile error: Syntax error". Thank You.

 

[Kenneth Hobson]

You passed 3 parameters. "=" implies one assignment. Pick which string you want to show. e.g.

Textbox1.Value = r1.address

 

[Pookiemeister]

Ok...Thank you