Thank you both, for your advice. Now I ll code it.

Read you around

Thanks again

Jose Luis


DM Unseen Wrote:
In the UserForm1 forms module have this:

Public Sub Myshow (strVal1 as string, bVal2 as boolean)

' do your stuff
Me.show
End sub

In a global module somewhere

UserForm1.MyShow string1,bool2

DM Unseen

PS this can me amended with Property Get/Let/Set procedures and whatnot


--
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