View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Controlling Change event when loading a form

You may want to post your form code.

Barb Reinhardt




"Gussie" wrote:

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.