View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BrianG[_3_] BrianG[_3_] is offline
external usenet poster
 
Posts: 20
Default Loosing variables help needed

I have created a purchase order form automating many functions using
VBA in Excel97. One problem I seem to be having is that when users
take a long time to file out the form they end up with a runtime error
caused be the loss of variables. How can I ensure all variables remain
defined until the user exits the worksheet?

--
BrianG