Good afternoon Jennifer Thomson

To show your userform use this line in your command button code:

UserForm1.Show

assuming it's called UserForm1, of course (Tender Information isn't
valid name).

These commands will close your userform (there is a subtle differenc
between the two commands)

UserForm1.Hide

or

Unload UserForm1

In terms of where your first entry will be, this is determined in th
objects property in the userform. Open a userform, click on any objec
and then look in the properties window for the TabIndex property. Th
objects will be cycled through in the order of their TabIndex propert
values.

HTH

Dominic

--
dominic
-----------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=46750