Excell: How to set a cell to display a variable 1

[klmorgan]

I have a macro in a worksheet that opens and updates links on a number of sheets and saves them.

This takes quiet a time and I would like to set a variable to the name of the sheet that is currently being updated and displaying it on the open sheet to let people know it is working and not stopped.

The vaiable I can load by:
mvar = "M:\Business Management Systems\1 Operations\Waterfall\Can Line Link.xls"

But how can I either put a box on screen to display this or make a cell on the controlling sheet equal to this so that people can see it?

Regards

Keith

 

[Nikita6003]

Hiya,

As I usually run macros with

Application.ScreenUpdating

set to False (this means you don't sit & watch the macro do its work - the screen 'freezes') I end up using the

Application.Statusbar

for displaying messages. It's quick & easy & will update even with ScreenUpdating set to False

All you do is add the line:
Application.Statusbar = "Please wait ... updating " & mvar
before the code starts running.
Before the

End Sub

, add

Application.Statusbar = False

to release the statusbar back to Excel - otherwise your message stays displayed until you quit Excel ;-)

HTH

Cheers
Nikki

 

[klmorgan]

Thanks for the help Nikki

Kind Regards

Keith