carrying over variable values

**tryer** · 09-07-2009, 06:02 AM

When I call a second subroutine (in the same module) from within the main code the values of my variables are not available in the second subroutine. I thought that variable values were available to any subroutines within the same module. I know I can declare tham as Public variables but then they will be available thoughout the whole project and this is not what I want.
Is is perhaps because of the way I am declaring them : with Dim statements at the begining of the main sub ? or is there something specific I have to do?

When stepping through the code I can see that a certain variable for example has a value of 6 in the main code but in the new sub this same variable is showing as 'empty'

**Andy Pope** · 09-07-2009, 06:14 AM

If the variable is declared within a routine then it's scope is restricted to that routine.

If you declare a private variable at the top of a module then it's scope is all routines within that module.

If you declare a public variable at the top of a module then it's scope is all routines within all modules of that vba project.

Please Login or Register  to view this content.

**DonkeyOte** · 09-07-2009, 06:14 AM

Sounds like you want something like below (note assumed based on your post you're not utilising Option Explicit)

Please Login or Register  to view this content.

Please Login or Register  to view this content.

strVar won't be accessible outside of Module 1

carrying over variable values

LinkBack

Thread Tools

Rate This Thread

Display

carrying over variable values

Re: carrying over variable values

Re: carrying over variable values

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions