View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gussie Gussie is offline
external usenet poster
 
Posts: 9
Default Controlling Change event when loading a form

I created an Excel Form 2000 which triggers when user double-clicks on a row,
loading information into the form. In the form there is a disabled SAVE
button that would be enabled when ever a CHANGE is detected.

The problem:
The CHANGE event gets triggered even while loading form, therefore SAVE
button gets enabled, even though no change has been done yet.

I am currently initializing a variable: LOADING_Flag=true when loading, then
controlling the flag as Initialize process is completed. It works but I was
wondering how others are addressing this issue.