You can ask the code to display a status message on the status bar so that the user is informed about the current status of the code.
Here is a simple code which gives a message box showing the values in column A starting from row 2 to the last row.
For more information, view the Desktop Contributions Application Guide.
You will not be able to use this software unless you have been setup as a contributor by a Bloomberg representative.
After the macro is finished, the status bar will show as follows – So similarly, you can update the status bar at different parts of the code, so that the user knows what is happening as the macro is running.
Here is a pic of the status bar while the macro is running.
Install or update the Excel add-in for EPS products.
Certain vba macros / codes take a long time to run or execute the actions required. Sometimes, there could be one or more macros which cover multiple processes and this status bar will be useful to know at which process, the macro has reached.