Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Display ModuleName in StatusBar 1

Status
Not open for further replies.

bojzon

IS-IT--Management
Sep 18, 2003
25
SI
Is it possible to display current (among many of them) running module name in excel status bar (WinXP, Off2003)?
Thanks!
Bojzon
 

You can specify any Status Bar text you like so, yes. What you need to do, though, is explicitly code it yourself in each module - and remember to set StatusBar to False at the end. All in all, it's probably more trouble than it's worth; what would be the real benefit?

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[
 
Application.StatusBar = ThisWorkbook.VBProject.VBComponents.VBE.ActiveCodePane.CodeModule
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top