Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
tracking a macro like the evaluate formula tool
Hello,
I would like to follow a macro through step by step through the VBA editor or some other method. My macro is not bringing up coding errors but the end result is not what I expected. I was hoping there is a process similar to the evaluate formula option. I am not an expert with macros so...any help is GREATLY appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
tracking a macro like the evaluate formula tool
You can put a breakpoint on the first line of code my selecting
that line in the editor and pressing F9. Code will pause when that line is executed. Then, you can use F8 to step through the code line by line. See http://www.cpearson.com/excel/Debug.htm for other tips on debugging code. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "rekoop" wrote in message ... Hello, I would like to follow a macro through step by step through the VBA editor or some other method. My macro is not bringing up coding errors but the end result is not what I expected. I was hoping there is a process similar to the evaluate formula option. I am not an expert with macros so...any help is GREATLY appreciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
tracking a macro like the evaluate formula tool
Thank-you!
rekoop -----Original Message----- You can put a breakpoint on the first line of code my selecting that line in the editor and pressing F9. Code will pause when that line is executed. Then, you can use F8 to step through the code line by line. See http://www.cpearson.com/excel/Debug.htm for other tips on debugging code. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "rekoop" wrote in message ... Hello, I would like to follow a macro through step by step through the VBA editor or some other method. My macro is not bringing up coding errors but the end result is not what I expected. I was hoping there is a process similar to the evaluate formula option. I am not an expert with macros so...any help is GREATLY appreciated. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A Real Estate Tracking Tool | Excel Discussion (Misc queries) | |||
Project Purchase & budget tracking tool | Excel Worksheet Functions | |||
I want to track tool utilization, tracking by hour and day. | Excel Discussion (Misc queries) | |||
Excel Tracking Tool | Excel Worksheet Functions | |||
PTO Tracking Tool | Excel Discussion (Misc queries) |