View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Passing variables between Sub and Userform

If you put that public variable in a general module, does it work ok?

jose luis wrote:

Hi All,

I have a sub that assigns a true value to a Boolean Variable. That sub
fires a Userform that needs that boolean value to see if a condition
was met in the sub and then assign certain value to other variable.

I tryed to declare it (Public SwdeLista as Boolean) in Thisworkbook to
make it global (even that i read this is not adviceable, i couldn't
figure another way!), but doesn't work. The SwdeLista boolean variable
keeps "empty".

Could you direct me on how to pass a variable (boolean) from a sub to a
Userform?

Thanks in advance

Jose Luis

--
jose luis
------------------------------------------------------------------------
jose luis's Profile: http://www.excelforum.com/member.php...o&userid=13312
View this thread: http://www.excelforum.com/showthread...hreadid=387892


--

Dave Peterson