I am reading myself through some older Excel macros (I'm teaching hacking) which is quite long. However, as I change a few lines, I have to make sure that I know when and where my new and re-handled elements are happening - or not. So my question is:
- How do I put a simple message box function that pops up when a loop / process / event ends?
- Add text (hard-coded course) to explain it?
- In addition, there is an "OK button" that starts the next process?
The breakpoint process can be the most effective way of doing this, but I want to use the message box approach so that I can show my colleagues what is happening. Apart from this, it will be something that I want to include in future projects.
Many thanks for any examples, links or helpful signals Michael.
just use
MsgBox ("message here") And if you want to go to the code, you can debug it using CTRL + BREAK
Comments
Post a Comment