Hyperlink Cell Reference

[ryan_law2000]

Is there a way that under "Type the Cell Reference" that you can make it automatically change to the cell the hyperlink is on?

The reason why i ask this is because I have hyperlinks linking to there current cell but once i delete a row above that... the cell refernece doesnt change therefore changing the cell reference to the cell above it

 

[ryan_law2000]

Actually that is a very good point...
Can I get this to work in this case:

The cell I select it opens the userform, then this userform will have a full description of every cell range in that row = "B" / "C" / "D"
I would like each cell desctription to have a slash in between... is this possible?
Lets say that it will be in textbox1

 

[Norie]

Well here's one way, though I would wonder why you want/need all the data in a single textbox.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim arrValues
    If Target.Count > 1 Then Exit Sub
    If Intersect(Range("A1:A500"), Target) Is Nothing Then Exit Sub
    
    arrValues = Target.Offset(, 1).Resize(, 3)
    
    arrValues = Application.Transpose(arrValues)
    
    arrValues = Application.Transpose(arrValues)
    UserForm1.TextBox1 = Join(arrValues, "/")
    
    UserForm1.Show
    
End Sub