VBA - Status Window?

  • Thread starter Thread starter jordanctc
  • Start date Start date
J

jordanctc

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
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What does the yellow triangle with an exclamation mark in Outlook mean? 1
Monitoring progress of Excel/VBA routines with a long runtime 5
VBA - Combine Workbooks 2
VBA - Flexible Sort Macro 2
Notepad status bar missing even after Registry entry 1
Suggestion for the Excel Development Team 1
Screen Updating For Status Bar 4
VBA - MS VB Compile Error 2

Back
Top