Hi

I am having a few problems creating a userform and a command button o
my worksheet to activate my userform. I am using excel 2003. I hav
situated the command button on the worksheet but how do I get this t
open my userform.

On the userform form I have a button which when pressed should ente
the details onto the form but it does not work. Here is my code fo
the button

private sub cmdOK_Click()

ActiveWorkbook.sheets("Tender Information"). activate

I thought this line would activate the sheet

and then I added
Range ("G2").select

End sub

this is where is want my first entry from my userform to go.

I am a novice to these features of excel and I would be very gratefu
to any replies with assistance.

Jennifer Thomso

--
jenniferThomso
-----------------------------------------------------------------------
jenniferThomson's Profile: http://www.excelforum.com/member.php...nfo&userid=456
View this thread: http://www.excelforum.com/showthread.php?threadid=46750