Hi,

I have two forms And i want to be able to pass variables from one for
to another. for example in form 1:

CurrentUser = TxtUser.value

then in form 2 i want to be able to use this variable eg

LblUser.Caption = CurrentUser

Where do i declare this variable in Vba and how?

I have tried a global variable in a standard module but this didn
work.

any help would be appreciated

thank

--
andywalke
-----------------------------------------------------------------------
andywalker's Profile: http://www.excelforum.com/member.php...fo&userid=2441
View this thread: http://www.excelforum.com/showthread.php?threadid=38222