Menu
Is there any way to get excel application status bar text?
Any answer would be appreciated.
495
The status bar at the bottom of Office programs displays status on options that are selected to appear on the status bar. Many options are selected by default. If you want to customize the status bar, right-click it, and then click the options that you want.
To check if this is the case, go to File > Options > Advanced. Under Display options for this workbook, look for Show status bar. If it's unchecked, check it and click OK. This should make the status bar reappear.
Excel Status bar displays information like the Cell Mode options, Calculation options (quick summary of numerical data (sum, average, count)), on/off status of keyboard keys (Caps Lock, Scroll Lock, and Num Lock), Page View buttons, Zoom slider control, Zoom Percentage Indicator etc.
Use the keyword “Application” to refer to the Excel application. Type a dot to get the list of properties and methods. Select the “StatusBar” property. In the end, use the equals sign to specify the value you want to display on the status bar.
I'm definitly not sure but you can try like this;
Microsoft.Office.Interop.Excel.Application interface has StatusBar property.
Returns or sets the text in the status bar.
This property returns False if Microsoft Excel has control of the status bar. To restore the default status bar text, set the property to False; this works even if the status bar is hidden.
71
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
