Good morning Mestrella29

Creating a userform is easy. Putting the code into it that drives it
is what causes the weeping and gnashing of teeth! To create the form
press alt + f11 from Excel and in the VBE select Insert Userform and
then simply draw the controls you require onto the form. It really is
that easy - but be prepared to put a lot of time into the code behind
it - especially if you're not used to VBA.

To call the form use:

Userform1.Show

and to dismiss it use either:

Userform1.Hide
or
Unload Userform1

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=375100