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?

To track down the actual problem, go to the Tools menu in VBA, choose
Options, then the General tab. In the "Error Trapping" section, select
"Break in Class Module". Now, rerun the code. VBA will debug on the
actual line of code causing the problem, not the code that called the
class (userform).

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Thu, 19 Mar 2009 10:02:02 -0700, Tony
wrote:

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?

Chip ist still stops on the same line

LienRegistrationForm.Show

"Tony" wrote:

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?