ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Displaying Messages (https://www.excelbanter.com/excel-discussion-misc-queries/1610-displaying-messages.html)

BillCPA

Displaying Messages
 
I would like to display an informational message, such as "Processing
Inventory Figures", on the screen while VB is running a process, without
stopping the process that is running. So that the message is displayed when
the process begins running, and is removed when the process finishes.

Is there some way to display a message like this (using a UserForm or
otherwise) in a VBA module?

--
Bill @ UAMS

Frank Kabel

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

"BillCPA" <Bill @ UAMS schrieb im Newsbeitrag
...
I would like to display an informational message, such as "Processing
Inventory Figures", on the screen while VB is running a process,

without
stopping the process that is running. So that the message is

displayed when
the process begins running, and is removed when the process finishes.

Is there some way to display a message like this (using a UserForm or
otherwise) in a VBA module?

--
Bill @ UAMS




All times are GMT +1. The time now is 02:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com