Step Through Function (F8 command) and Checking Variables -- Not working?

**NicholasL** · 06-20-2013, 09:04 AM

Hello, so I'm working on a fairly complex (for me) bit of code and it would help me to be able to step through the code one line at a time and watch it work to make sure nothing unexpected happens.

Previously I was told about using F8 to walk through the code like this but I can't seem to get it to work. I should note that I'm on a 2012 Macbook Pro. My F8 key is actually a play/pause button for media, but it is a regular F8 key if I hold down the "fn" button on my keyboard. I'm not sure if this works differently on macs than on windows? Also, I'm using Excel 2011.

In addition, my code uses variables frequently and I was wondering if it was possible to bring up some kind of screen that displays the values the computer has for the variables so I can make sure it's handling of the variables is fine.

Thank you very much.

**ragulduy** · 06-20-2013, 09:13 AM

Try CMD+SHIFT+I

(Or in the menu, debug -> step into, might tell you what the shortcut is next to it I guess).

**JosephP** · 06-20-2013, 09:14 AM

you need the Locals window. f8 is not the same on the mac-I think it's cmd+shift+I but you can check the keys on the 'Debug-step into' menu command

**NicholasL** · 06-20-2013, 09:18 AM

cmd + shift + I worked perfectly, thanks!

Any idea on keeping track of variable values?

**ragulduy** · 06-20-2013, 09:21 AM

Add a watch for the variable (Debug->Add watch menu command) and type the variable name you want to keep track of. Alternatively highlight variable and "right click" and you should have an add watch option.