View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tony tony is offline
external usenet poster
 
Posts: 313
Default .show starts debugger upon window change

When I open a form using a macro button, I enter some data then click on
another macro button to copy form data to the spreadhsheet. When I try to go
back to another window to get more data, the VBA Debugger opens up and hight
lights the following statement:

LienRegistrationForm.Show

I have to close the debugger which closes the form and I lose the form with
the data. The statements prior to that just clear spreadsheets cells, which
works fine.

Any ideas?