Hello Chris

Add a Command button to Excel double click it so it takes you to the vb
code & enter UserForm1.Show (between Private Sub CommandButton1_Click()
& End Sub)
& then click the add userform button (it's next to the save disk on the
tool bar).
& that's it.

Cheers Lee


--
robmeister
------------------------------------------------------------------------
robmeister's Profile: http://www.excelforum.com/member.php...o&userid=24364
View this thread: http://www.excelforum.com/showthread...hreadid=380247