Using

GLOBAL vname as vType

in place of:

Dim vname as vType

will make the varable available to all running processes for as long as this
instance of Excel remains open/running

bac

"Lee" wrote:

How do I declare a vairiable that will be available in other forms, I'm new
to VB and will need some examples please.