Is there any way to list all the variables used in a VBA project? I would
prefer this to also list the subroutines they occur in, but that's not
essential.

ian

On Apr 15, 8:44*am, "Ian" wrote:
Is there any way to list all the variables used in a VBA project? I would
prefer this to also list the subroutines they occur in, but that's not
essential.

ian

There are a great many programs out there - see he
http://code-snippet-manager.qarchive.org/

What I have done is this:
Copy all the code from the VBE, paste it into excel, then delete all
rows that don't start with "Private", "Public" or "Dim" ....

HTH

Chris

Thanks, Chris, but I was hoping for something free. This costs $40.

Your DIY method will only work if all the variables have a Dim line
associated with them, which is certainly not he case with the code I'm
trying to fathom just now.

Ian

"cht13er" wrote in message
...
On Apr 15, 8:44 am, "Ian" wrote:
Is there any way to list all the variables used in a VBA project? I would
prefer this to also list the subroutines they occur in, but that's not
essential.

ian

There are a great many programs out there - see he
http://code-snippet-manager.qarchive.org/

What I have done is this:
Copy all the code from the VBE, paste it into excel, then delete all
rows that don't start with "Private", "Public" or "Dim" ....

HTH

Chris

On Apr 15, 9:27*am, "Ian" wrote:
Thanks, Chris, but I was hoping for something free. This costs $40.

Your DIY method will only work if all the variables have a Dim line
associated with them, which is certainly not he case with the code I'm
trying to fathom just now.

Ian

"cht13er" wrote in message

...
On Apr 15, 8:44 am, "Ian" wrote:

Is there any way to list all the variables used in a VBA project? I would
prefer this to also list the subroutines they occur in, but that's not
essential.

ian

There are a great many programs out there - see hehttp://code-snippet-manager.qarchive.org/

What I have done is this:
Copy all the code from the VBE, paste it into excel, then delete all
rows that don't start with "Private", "Public" or "Dim" ....

HTH

Chris

No proper declarations? Eep! Put "Option Explicit" at the very top of
every Module, and start declaring (may be too much work, but might be
worth it?)

I did another google search, and I don't see anything for free ... I
bet that one of the experts will have something, though :)

Chris

On Apr 16, 12:03*am, cht13er wrote:
On Apr 15, 9:27*am, "Ian" wrote:





Thanks, Chris, but I was hoping for something free. This costs $40.

Your DIY method will only work if all the variables have a Dim line
associated with them, which is certainly not he case with the code I'm
trying to fathom just now.

Ian

"cht13er" wrote in message

...
On Apr 15, 8:44 am, "Ian" wrote:

Is there any way to list all the variables used in a VBA project? I would
prefer this to also list the subroutines they occur in, but that's not
essential.

ian

There are a great many programs out there - see hehttp://code-snippet-manager.qarchive.org/

What I have done is this:
Copy all the code from the VBE, paste it into excel, then delete all
rows that don't start with "Private", "Public" or "Dim" ....

HTH

Chris

No proper declarations? Eep! Put "Option Explicit" at the very top of
every Module, and start declaring (may be too much work, but might be
worth it?)

I did another google search, and I don't see anything for free ... I
bet that one of the experts will have something, though :)

Chris- Hide quoted text -

- Show quoted text -

Hi,

Not sure exactly what you need to achieve, but within the VBA
environment, you could try upening the 'Locals' window. Head for
'View' - 'Locals'. Once this is visible, step through your code and
all the active variables will be listed with their values and types.
Might help you.

Cheers,
Ivan.

Hi Ivan

All I was hoping for was a list of the variables and ideally which
subroutines they are used in. This is even better.

Absolutely perfect!

Many thanks.

Ian
"Ivyleaf" wrote in message
...
On Apr 16, 12:03 am, cht13er wrote:
On Apr 15, 9:27 am, "Ian" wrote:





Thanks, Chris, but I was hoping for something free. This costs $40.

Your DIY method will only work if all the variables have a Dim line
associated with them, which is certainly not he case with the code I'm
trying to fathom just now.

Ian

"cht13er" wrote in message

...
On Apr 15, 8:44 am, "Ian" wrote:

Is there any way to list all the variables used in a VBA project? I
would
prefer this to also list the subroutines they occur in, but that's not
essential.

ian

There are a great many programs out there - see
hehttp://code-snippet-manager.qarchive.org/

What I have done is this:
Copy all the code from the VBE, paste it into excel, then delete all
rows that don't start with "Private", "Public" or "Dim" ....

HTH

Chris

No proper declarations? Eep! Put "Option Explicit" at the very top of
every Module, and start declaring (may be too much work, but might be
worth it?)

I did another google search, and I don't see anything for free ... I
bet that one of the experts will have something, though :)

Chris- Hide quoted text -

- Show quoted text -

Hi,

Not sure exactly what you need to achieve, but within the VBA
environment, you could try upening the 'Locals' window. Head for
'View' - 'Locals'. Once this is visible, step through your code and
all the active variables will be listed with their values and types.
Might help you.

Cheers,
Ivan.