Your Select Case statement is unnecessary. Get rid of it. The proble
you're getting comes from the fact that the "form" you created in th
worksheet is not a "Form" as we generally refer to in Excel. Go int
your VBA editor and on the main menu select Insert--User Form. Wha
gets added is something you could make up to take the same information
but requires you to add all the fields and titles and buttons yourself
From there the information may be placed into the spreadsheet anywher
you'd like. The code you would use to call that form is:

Form1.Show

Though giving it all the functionality you want will be a little (bu
not much) more involved. - Piku

--
Message posted from http://www.ExcelForum.com