want keep the value of a variant from one form to another

got a small application with many form creating a workbook, and i got often from workbook with data to new workbook, lets nama this variant wbname.

I tried to declare it as a static but when i star a new form the is still nothing how come, maybe i declare it in the wrong place (the first form module)

hope some knows

Best way to achive this is to declare your variable as public in and Bas module.


eg.

VB Code:

Public wbname as variant

Hope this helps

:wave: :thumb: :wave:

thanks a lot and sorry for the mistaping

do i have to say that the treat is solved

it look like it is resolved i have to say

if you want resolved in the original post title, open the thread, on the first post click edit then add *resolved* or (Resolved) to the end of the title (or the begining) then click save.

Vince