| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I watch a variable change value during Visual Basic Cod
in the code add:
Debug.Print variablename "Stewart1234" wrote: Thanks, that was very helpful, especially once I found the statusbar. Is there a way to display this on the VBE editor screen? When the workbook is displayed there is a lot of activity on the worksheets - numbers flying everywhere, and I like to cover this by expanding the VBE editor screen to full size, but it covers the status bar. I tried balloons, msgbox, textbox, etc but none of those had a display only feature, they always waited for an event before execution would continue. "Patrick Molloy" wrote: After the line where the code changes the variable's value add this: Application.Statusbar = variablename Patrick Molloy Microsoft Excel MVP "Stewart1234" wrote: How do I watch a variable in an excel macro change value as the visual basic code is running? The variable changes value every 30 seconds or so and I want to monitor progress of the execution by looking at the value without stopping the run. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Visual Basic - Variable Sheet Names | Excel Discussion (Misc queries) | |||
| I need a visual basic code....please | Excel Discussion (Misc queries) | |||
| visual basic code | Excel Programming | |||
| Visual Basic Code | Excel Programming | |||
| Visual Basic Range variable | Excel Programming | |||
![Patrick Molloy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
