View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default using Global variable of Userform in module

I think the easiest thing to do is to move the declaration to a general module.

Public MyVar as WhatEver



Anoop wrote:

Hi
I'm a fresher to VBA scripting. I'm trying to assign a value to a global
variable defined in Userform' General Declaration and then using that value
in my module.

tried my way but values are blank when my Userform ends.

any suggestion would be a gr8 help. Calling all life savers..."HELP".


--

Dave Peterson