You may not need a userfrom--maybe Data|Form would be sufficient.

But if you want a userform, check out Debra Dalgleish's site:
http://contextures.com/xlUserForm01.html

Keith wrote:

Hi all,

I have created a user form VBA. When I open the VBA Project window I have:

VBAProject (file name)
+ Microsoft Excel Objects
Sheet 1
This Workbook
+ Forms
Name of the form I created

What I want to do in the spreadsheet is create a command that when clicked
will bring this form up. The boxes in the form are designed to go to various
cells in the worksheet. How do I accomplish this? Is there a code that I
am supposed to write that will automatically go the form? I am not the
greatest when coming to working with commands in Excel. Any help would be
greatly appreaciated.

Thanks
Keith

--
Keith Pitner
Illinois

--

Dave Peterson