in the userform code, have this:

Option Explicit
Public SwdeLista As Boolean

in a code module have this:

Option Explicit
Sub ShowMyForm()
' load the form into memory
Load UserForm1
'adjust any values
UserForm1.SwdeLista = True
'show the form
UserForm1.Show
End Sub



"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