Suspend Macro to Allow mod of Wksht

[Guest_imported]

Hi,

I am writing a pretty involved VBA for excel 2000 application utilizing one or more forms and several modules.

When the vba is executed, the main form appears but from that point on, the user cannot modify the worksheet until the vba is stopped. Is there a way to run the VBA in the background while allowing the user to select cells, modify them, etc, but then come back to the form without stopping macro and losing state?

(Similar to the formula/function form which allows you to select cells/ranges at the same time the form is visible)

Thanks,

reg.

 

[kevinclark]

Change the ShowModal property of the Form to False.

 

[Guest_imported]

kevin,

thanks so much! i use to program in VB a lot but this little property complete slipped my mind.

r