Public Variable loosing value

[Rudi]

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.

[Rudi]

Argh! ... sorry, I found it!
I had a double declaration. I removed the lesser scoped variable and the value passed.

TX