Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Status Bar Message
After running a simple macro on a worksheet, the status bar reads
"table:1" then "table:2" and finally "table:3". I've never seen this before. Why is excel displaying these messages? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Status Bar Message
This is because there is some code in the macro that is telling the status
bar to display this. Application.StatusBar = "table:1" Most likely this was done so that the person running the macro will have some sort of status indicating how far the code has run. HTH, Paul -- wrote in message ... After running a simple macro on a worksheet, the status bar reads "table:1" then "table:2" and finally "table:3". I've never seen this before. Why is excel displaying these messages? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Status Bar Message
The macro must be changing the Application.StatusBar Property. Maybe the
code looks something like this Sub YourCode() Application.StatusBar = "table:1" 'some code Applicaiton.StatusBar = "table:2" 'some more code Application.StatusBar = False End Sub Make sure that you set the Status Bar = False at the end of the Procedure to give control back to Excel like I did in the example. Else the Status Bar will be stuck on "table:3" -- Cheers, Ryan " wrote: After running a simple macro on a worksheet, the status bar reads "table:1" then "table:2" and finally "table:3". I've never seen this before. Why is excel displaying these messages? Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Status Bar Message
On Sep 3, 5:59*pm, RyanH wrote:
The macro must be changing the Application.StatusBar Property. *Maybe the code looks something like this Sub YourCode() Application.StatusBar = "table:1" * *'some code Applicaiton.StatusBar = "table:2" * *'some more code Application.StatusBar = False End Sub Make sure that you set the Status Bar = False at the end of the Procedure to give control back to Excel like I did in the example. *Else the Status Bar will be stuck on "table:3" -- Cheers, Ryan " wrote: After running a simple macro on a worksheet, the status bar reads "table:1" then "table:2" and finally "table:3". *I've never seen this before. *Why is excel displaying these messages? Thanks- Hide quoted text - - Show quoted text - There is nothing in the code that references the Status Bar. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Status Bar Message
Do you have the code to post? Is the code calling anyother procedures? Is
the macro opening other workbooks that may contain the code that is changing the Status Bar? Is the macro in your personal workbook? Some where in the project the Status Bar is being changed by code. It helps if you post your code so when all can analysis it in the future. -- Cheers, Ryan " wrote: On Sep 3, 5:59 pm, RyanH wrote: The macro must be changing the Application.StatusBar Property. Maybe the code looks something like this Sub YourCode() Application.StatusBar = "table:1" 'some code Applicaiton.StatusBar = "table:2" 'some more code Application.StatusBar = False End Sub Make sure that you set the Status Bar = False at the end of the Procedure to give control back to Excel like I did in the example. Else the Status Bar will be stuck on "table:3" -- Cheers, Ryan " wrote: After running a simple macro on a worksheet, the status bar reads "table:1" then "table:2" and finally "table:3". I've never seen this before. Why is excel displaying these messages? Thanks- Hide quoted text - - Show quoted text - There is nothing in the code that references the Status Bar. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Status Bar Message
On Sep 4, 8:31*am, RyanH wrote:
Do you have the code to post? *Is the code calling anyother procedures? *Is the macro opening other workbooks that may contain the code that is changing the Status Bar? *Is the macro in your personal workbook? Some where in the project the Status Bar is being changed by code. *It helps if you post your code so when all can analysis it in the future. -- Cheers, Ryan " wrote: On Sep 3, 5:59 pm, RyanH wrote: The macro must be changing the Application.StatusBar Property. *Maybe the code looks something like this Sub YourCode() Application.StatusBar = "table:1" * *'some code Applicaiton.StatusBar = "table:2" * *'some more code Application.StatusBar = False End Sub Make sure that you set the Status Bar = False at the end of the Procedure to give control back to Excel like I did in the example. *Else the Status Bar will be stuck on "table:3" -- Cheers, Ryan " wrote: After running a simple macro on a worksheet, the status bar reads "table:1" then "table:2" and finally "table:3". *I've never seen this before. *Why is excel displaying these messages? Thanks- Hide quoted text - - Show quoted text - There is nothing in the code that references the Status Bar.- Hide quoted text - - Show quoted text - I want to post the code...What are the correct tags I need to put around the code in order to post it correctly? Sorry to ask this here. I've been searching everywhere and cannot find this answer! |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Status Bar Message
To make sure the StatusBar code isn't in the current project, perform a
search in your VB code. Press Alt+F11 to enter the VB Editor. If your VBAProject Excel filename has a plus (+) next to it, click the plus onces. If it had a minus (-) next to it, then click it twice. This will ensure that this project is active. Next, click your mouse cursor in the right-hand pane. Press Ctrl+F. This should bring up the Find window. Next to Find What, type "StatusBar". Make sure "Current Project" is selected. Click Find Next. If the "StatusBar" code is in the current project, then it should be found. As for posting the code, there may be a lot in several modules or other places. HTH, Paul -- wrote in message ... On Sep 4, 8:31 am, RyanH wrote: Do you have the code to post? Is the code calling anyother procedures? Is the macro opening other workbooks that may contain the code that is changing the Status Bar? Is the macro in your personal workbook? Some where in the project the Status Bar is being changed by code. It helps if you post your code so when all can analysis it in the future. -- Cheers, Ryan " wrote: On Sep 3, 5:59 pm, RyanH wrote: The macro must be changing the Application.StatusBar Property. Maybe the code looks something like this Sub YourCode() Application.StatusBar = "table:1" 'some code Applicaiton.StatusBar = "table:2" 'some more code Application.StatusBar = False End Sub Make sure that you set the Status Bar = False at the end of the Procedure to give control back to Excel like I did in the example. Else the Status Bar will be stuck on "table:3" -- Cheers, Ryan " wrote: After running a simple macro on a worksheet, the status bar reads "table:1" then "table:2" and finally "table:3". I've never seen this before. Why is excel displaying these messages? Thanks- Hide quoted text - - Show quoted text - There is nothing in the code that references the Status Bar.- Hide quoted text - - Show quoted text - I want to post the code...What are the correct tags I need to put around the code in order to post it correctly? Sorry to ask this here. I've been searching everywhere and cannot find this answer! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate message in status bar | Excel Discussion (Misc queries) | |||
my message in Status bar | Excel Programming | |||
progress message in status bar | Excel Programming | |||
Status Message | Excel Programming | |||
'Calculate' message at the status bar | Excel Programming |