Hello,
I have a macro residing in a module which needs to modify the value of a global variable declared and residing in sheet 1 code.
When I click a button, the associated macro edits a cell and then calls the worksheet change event in sheet 1, at this point, the
worksheet change event sets a GlobVar to 1. Which is ok because it is harmless under this context.
However, when the worksheet change event completes it comes back to my macro which I must reset GlobVar to 0 like this:
GlobVar = 0
Then the next time the worksheet change event gets called by other changes, I would expect to see GlogVar to 0 but I don't and
GlobVar is still 1.
Why why !!!
GlobVar is declared as Public!!!!!!
Anyone know why this is happening
RN
Bookmarks