understanding a macro

drag-driver · Apr 23rd, 2002, 03:33 AM

I have got a program which was designed by someone else and i need to step through the macro to figure out whta is happening any tips are advice on how to do this much apreciated.

Thomas

gareth · Apr 23rd, 2002, 04:06 AM

Goto

http://www.fontstuff.com/vba/index.htm

I am sure you will learn how to it on the site

Many thanks friend

Iain Lewis · Apr 23rd, 2002, 04:34 AM

Have you tried inserting breakpoints in the code ? Select a line in the code ( just click on it ) & press F9. This will put a dot at the start of the line & turn it brown ( assuming you're using the default colours ). Then when you run the code the macro will pause at each breakpoint ( you can insert as many as wyou want, but they're not allowed on some lines of code ). Each time it pauses press F5 to continue running the macro.

Mudface · Apr 23rd, 2002, 04:35 AM

Also, try setting breakpoints on the lines you aren't sure of and keeping an eye on the variables in the locals window.

Edit- sorry Ian, seconds after your post

.

[ This Message was edited by: Mudface on 2002-04-23 03:36 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 03:33 AM	#1
drag-driver Board Regular Join Date: Feb 2002 Posts: 91	I have got a program which was designed by someone else and i need to step through the macro to figure out whta is happening any tips are advice on how to do this much apreciated. Thomas

Apr 23rd, 2002, 04:06 AM	#2
gareth Board Regular Join Date: Apr 2002 Location: Cape Town,South Africa Posts: 234	Goto http://www.fontstuff.com/vba/index.htm I am sure you will learn how to it on the site Many thanks friend

Apr 23rd, 2002, 04:34 AM	#3
Iain Lewis Board Regular Join Date: Apr 2002 Location: Midlands, UK Posts: 217	Have you tried inserting breakpoints in the code ? Select a line in the code ( just click on it ) & press F9. This will put a dot at the start of the line & turn it brown ( assuming you're using the default colours ). Then when you run the code the macro will pause at each breakpoint ( you can insert as many as wyou want, but they're not allowed on some lines of code ). Each time it pauses press F5 to continue running the macro.

Apr 23rd, 2002, 04:35 AM	#4
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Also, try setting breakpoints on the lines you aren't sure of and keeping an eye on the variables in the locals window. Edit- sorry Ian, seconds after your post . [ This Message was edited by: Mudface on 2002-04-23 03:36 ]