| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using the "Ready" Message Bar instead of MSBOX
I know it is possible to output messages on the "Ready"
bar (located on the bottom of the screen) instead of using pop-ups (MsgBox). Does anyone know how to do this? If so, please share. Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using the "Ready" Message Bar instead of MSBOX
Ked,
You can use status bar to display messages. For example, Application.StatusBar = "Hello World" To return control of the status bar back to Excel, use Application.StatusBar = False -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Keda Wang" wrote in message ... I know it is possible to output messages on the "Ready" bar (located on the bottom of the screen) instead of using pop-ups (MsgBox). Does anyone know how to do this? If so, please share. Thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using the "Ready" Message Bar instead of MSBOX
Perfect! Thanks Chip!
-Keda -----Original Message----- Ked, You can use status bar to display messages. For example, Application.StatusBar = "Hello World" To return control of the status bar back to Excel, use Application.StatusBar = False -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Keda Wang" wrote in message ... I know it is possible to output messages on the "Ready" bar (located on the bottom of the screen) instead of using pop-ups (MsgBox). Does anyone know how to do this? If so, please share. Thanks! . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using the "Ready" Message Bar instead of MSBOX
Application.StatusBar="My Message String"
Reset it at the end of the macro with := Application.StatusBar=False --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Turn off "CALCULATE" on bottom of Excel worksheet. near "Ready" | Excel Discussion (Misc queries) | |||
| "excel "macros may be disabled" message using an xlam file | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| when excel opens it is in "ready mode" | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Linear Mode
