jsunnb, be careful. Public variables that are declared in a standard module, live until you close the program. Public variables that are declared in a class module (UserForm1), they live until unloading form.

Artik