ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Output while working? (https://www.excelbanter.com/excel-programming/277684-output-while-working.html)

Jens 'Kluesi' Kluesener

Output while working?
 
Hi

Sorry for my bad english. I have got a form. If I press the button x then a
function with many code lines will works. To show the user that the VBA
program works I want to put some progress information on this form. So I
put a Label in the form and write some informations in it at some positions
of the code. But the informations does not show in the label.

How can I do that?

Many thanks

Jens

Tom Ogilvy

Output while working?
 
write the label than have the command

doEvents

--
Regards,
Tom Ogilvy

"Jens 'Kluesi' Kluesener" wrote in message
...
Hi

Sorry for my bad english. I have got a form. If I press the button x then

a
function with many code lines will works. To show the user that the VBA
program works I want to put some progress information on this form. So I
put a Label in the form and write some informations in it at some

positions
of the code. But the informations does not show in the label.

How can I do that?

Many thanks

Jens





All times are GMT +1. The time now is 06:31 AM.

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