Hi,
I must be missing something here....but I cannot figure out why the sWB variable (declared as Public on a standard module) looses its value when I try and use it in a Userform module. Is it to do with the Private Status of the code on this module? Any guidance would be appreciated. TX.
Public Variable loosing value
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Public Variable loosing value
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Public Variable loosing value
Argh! ... sorry, I found it!
I had a double declaration. I removed the lesser scoped variable and the value passed.
TX
I had a double declaration. I removed the lesser scoped variable and the value passed.
TX
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.