Declared variables in excel vba

**RALIR** · 04-12-2015, 04:28 PM

In Excel VBE, I can see a listing all the variables declared, subroutine names, etc in the Object Browser screen, under the Member of the VB Project. Is there a simple way to access this listing through VBA code? Basically, I am interested in generating a list of all the declared variables and then determining which of these variables have not been used.
Currently, the alternative I am looking at is getting the declared lines from a VBIDE procedure and manipulating those lines. Since this listing seems to be already in Excel, I am wondering if there is a way to capture it through VBA codes.
Thanks for any help I can get on this.
Regards,
RaliR

**jaslake** · 04-12-2015, 04:37 PM

Hi RALIR

Go to this Web Site and download MZ Tools (freeware). It has a Utility that allows you to Review your Code and will tell you if Variables are not used. I use it every day.

http://www.mztools.com/v3/download.aspx

**RALIR** · 04-12-2015, 05:08 PM

Hi John,

Thank you for the quick response. I am familiar with MZTools and it worked well with Excel 2007, but unfortunately, it does not support Excel 2013. In addition, i am trying to get a listing of declared variables within VBA so that I can develop a robust debugging tool for my needs. If you have other thoughts, I would like to hear them.

Thank you again.

Regards,
RaliR

**jaslake** · 04-12-2015, 05:26 PM

Hi RaliR

Don't have 2013...but...I'll think on it...

**FDibbins** · 04-12-2015, 05:36 PM

John, I looked at that site. It has a version that supposrts 2013 32 bit, but it does not support 64 bit

(darn, just tried to run it here (at work) but I need admin permiission to install it)

**jaslake** · 04-12-2015, 05:41 PM

@Ford

This is Sunday

just tried to run it here (at work)

Pulled many of those myself...in the day

I believe the OP is wanting to do something a bit different than MZTools can offer

i am trying to get a listing of declared variables within VBA so that I can develop a robust debugging tool for my needs.

Have no ideas at the moment...

**FDibbins** · 04-12-2015, 05:43 PM

John, my week is Wed-Sun and my W/E is (normally) Mon/Tues - so for me its Friday

lol

**jaslake** · 04-12-2015, 06:03 PM

@Ford

Ah...I see. Well, when you retire, as I've been for going on 15 years, you'll find that EVERY day is a work day, especially if you have Children. I don't knock it...quite love it.