Excel VBA Form Trouble 1

[RoguePoet01]

I'm trying to include a "Please Wait" form in an Excel workbook.

I want it to appear while records are being transferred from the spreadsheet to the SQL database, but every time I call the form with a "frmWait.Show" the program locks up.

Any ideas how to fix this?

Thanks

 

[IvanMoala]

Are you sure it is locked up or just waiting for the SQL Macro to finish it's parse....try puting in a DoEvents before your call to the Form show ??

 

[JoanneM]

Morning RP
I know I could be teaching you how to suck eggs but...
If the form is modal this could be your problem as nothing can continue until the box is close.

Regards

Jo

 

[RoguePoet01]

Jo,

That was the ticket home!

I'll take a rain check on your other offer....