D
Desmond Walsh
A question on VBA coding in Excel 10.
I maintain various items of status in a custom data structure (Budget) defined by a Type statement. i.e.
Type Budget
....
End Type
The definition of this data structure is coded in a Module outside the subroutines and functions that define my code. I also set up a Public reference (bref) to this data structure in the same location i.e.
Public bref As Budget
The data structure Budget is populated in my Main macro that is called to create a summary of some data from an external database. However when I enter the event handler Worksheet_BeforeDoubleClick, I find I have no access to the data in Budget.
I expected to have access to Budget everywhere in my code including worksheet event handlers. Is there another technique to pass data into the set up event handlers set up by excel.
Thanks
I maintain various items of status in a custom data structure (Budget) defined by a Type statement. i.e.
Type Budget
....
End Type
The definition of this data structure is coded in a Module outside the subroutines and functions that define my code. I also set up a Public reference (bref) to this data structure in the same location i.e.
Public bref As Budget
The data structure Budget is populated in my Main macro that is called to create a summary of some data from an external database. However when I enter the event handler Worksheet_BeforeDoubleClick, I find I have no access to the data in Budget.
I expected to have access to Budget everywhere in my code including worksheet event handlers. Is there another technique to pass data into the set up event handlers set up by excel.
Thanks