EXCEL: Value Changed After End Sub

[gaikwad.mm@gmail.com]

I' have created 1 Integer in Module,

Set the Value as "1" in Module RunTime [WrokBook Open = 0]

I' want to use the same in WorkSheet Selection Change Event,

But After Module End Sub, The Value is coming back to 0

Need Help with the same.

[JosephP]

sounds like you declared the variable with the wrong scope-did you declare it public?

[gaikwad.mm@gmail.com]

Yes

I' have declared it Public

Also Tried declaring both at Workbook & Module level

Still it is not working

As Below:
Public DSPCheck As Integer

[JosephP]

that oughta work. where is that code located?

[Norie]

It should be declared once, in a standard module.

[gaikwad.mm@gmail.com]

i' am saying that I' have tried at both location... not at the same time

[JosephP]

it should work unless you reset the code state. please provide a workbook showing where it doesn't work

[Norie]

Well if it's been declared in a standard module and has been given a value in workbook open it should still have that value, unless something has happened inbetween that could cause it to lose it's value.

[gaikwad.mm@gmail.com]

I' am not able to find which code is running in between
can we get the sequence of code run [no debugging because more than thousand rows] so I' can find where it is getting change.

[JosephP]

you need to learn how to debug ;-)
add a watch to the variable and set it to break whenever the value changes