Hello,
I am having a little bit problem with the way Excel works with VB.
I have a button in my Worksheet that calls a method which defines:
Dim data As DataType
data.name = "name"
data.type = "type"
...
Then on Worksheet_SelectionChange I call a function which should use "data" variable and the row and column of the cell clicked.
The "data" variable is not available in Worksheet_SelectionChange.
How can I solve this?
,
Miguel
Should I define the data variable in some other Worksheet event?
Thank You
Private Sub Worksheet_SelectionChange(ByVal Target As range)
Bookmarks