Didn't I read somewhere that you can create a status/progress window?

I know forms stop the VBA so what's the secret?

Jorda

--
Message posted from http://www.ExcelForum.com

Hi
see:
http://www.enhanceddatasystems.com/E...rogressBar.htm
http://www.cpearson.com/excel/Progress.htm
http://j-walk.com/ss/excel/files/developer.htm

--
Regards
Frank Kabel
Frankfurt, Germany


Didn't I read somewhere that you can create a status/progress window?

I know forms stop the VBA so what's the secret?

Jordan


---
Message posted from http://www.ExcelForum.com/

A Message will pause the flow of the VBA code, but a form won't.
Just use the progressbar control (right-click the toolbox in the VBE and do
additional controls and add the progressbar control) on a form and set the
value.

RBS


"jordanctc " wrote in message
...
Didn't I read somewhere that you can create a status/progress window?

I know forms stop the VBA so what's the secret?

Jordan


---
Message posted from http://www.ExcelForum.com/

You can have a modeless form from Excel 2000 onwards. Call the form like so:

MyForm.Show vbModeless

Then it won't stop the rest of your code.

Jeff

"jordanctc " wrote in message
...
Didn't I read somewhere that you can create a status/progress window?

I know forms stop the VBA so what's the secret?

Jordan


---
Message posted from http://www.ExcelForum.com/