Displaying a Progress Message

[klyhthwy]

Hello,

I am looking for a way to display a message box in VBA that will not provide any options (i.e. Ok, Cancel), but will just display a message to "Please Wait" while another process is running. I would like the message box to be cleared when the process is complete.

Any good way to do this?

Thanks,

Kelly

 

[shg]

I was not able to access his VBA code, which would have made it nice to see how he did all those various Progress Meters.

All of Andy's code is accessible in his workbook linked at http://www.andypope.info/vba/pmeter.htm

 

[chuckchuckit]

I saw examples of code there, but did not see the full code, unless I missed something.

Such as I was trying to access his "Status Bar" code and was not able to.

 

[shg]

The bulk of the code is in the UserForm1 code module.

 

[chuckchuckit]

UserForm1 has properties etc, but the VBA code to run in Module1 only shows:

Sub ShowProgress()
    UserForm1.Show
End Sub

I don't see any other code.

 

[chuckchuckit]

Ahh, I found it. Have to click "view Code" for the UserForm.

 

[shg]

Right click the userform module and select View Code.

Or double-click the userform module to see the form, and press F7 to see the code.

 

[chuckchuckit]

Looks like he is not using the vbModeless parameter with UserForm, so likely his Progress Meter screens will tie up Excel use until done. One could play around with that in the code to perhaps get the Excel instance freed up while his UserForm code is running.

 

[shg]

It's a demonstration of progress meters, chuck. I think Andy fairly assumes that people who intend to adapt one to their own purposes have some knowledge of VBA.

 

[chuckchuckit]

Yes, and that is some very nice code he has there. Learning how to use UserForms along with his example code should cover most anything.

Thanks shg.

 

[klyhthwy]

Thank you for all your input. It has been very helpful!

I didn't mention that I am actually using an Access module to run the code with the Excel library included. So I also have the Access libraries available.

Thank you all