UserForm Reads contents from the selected cell

[No-data]

Hi guys!
Here is my problem: I want to show selected cell's content into
an userForm's TextBox. I've tried to use the Worksheet_SelectionChange event without succes. Here is my code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
        Static Direccion As String
        Direccion = Target.Address(False, False)
        MsgBox Direccion
        Cells(6, "Q").Value = Target.Value
        UserForm2.Show
    
End Sub

My idea is to get the addres of the current selection with the Worksheet_SelectionChange event, save it to a variable called "Direccion" and when I initialize my UserForm read the value from the "Direccion" Variable into the textBox. However I the values is not showed =(.

and

Private Sub UserForm_Initialize()
 
 
 txtPerfil.Value = Direccion
 'Target.Address(False, False)

End Sub

Hope someone could help me!

 

[mvptomlinson]

The variable "Direccion" is only visible within the SelectionChange event. Modules outside that event cannot use it or reference it. In order to do so, create a Standard Module and in it declare a Public variable. You can then reference that variable in any module or sub within the vba project.

Public Direccion as String

Also remember to remove the Static variable you declared in the SelectionChange event!