How can I view the values of variables while I am debugging a macro in excel 2011

**donalddeakin** · 01-05-2016, 11:26 AM

**Norie** · 01-05-2016, 11:30 AM

You can use the Locals Window to view all local variables or to watch specific variables you can add them to the Watch Window.

Both windows are available via the View menu in the VBE.

**donalddeakin** · 01-05-2016, 11:48 AM

Thank you. How do I stop anyone else responding to my question? I am sorted.

How can I view the values of variables while I am debugging a macro in excel 2011

LinkBack

Thread Tools

Rate This Thread

Display

How can I view the values of variables while I am debugging a macro in excel 2011

Re: How can I view the values of variables while I am debugging a macro in excel 2011

Re: How can I view the values of variables while I am debugging a macro in excel 2011

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Max and Min VBA macro (Excel for Mac 2011)

Mac Excel 2011 - How To Create Shortcuts When Entering Variables

Macro Error using Office for MAC 2011 running Excel Files and Macro's Created on PC Excel

[SOLVED] Macro/vba to change date format from 01.01.2011 to 01/01/2011

EXCEL 2011 Mac Macro

Help with Date Macros - eg. Change Values From Jun 5, 2011 to 05/06/2011

Windows 7 :Windows 7 keeps closing Excel during macro debugging

macro that finds variables in one column and enters values if variables found

Bookmarks

Bookmarks

Posting Permissions