Put "put user form" in spreadsheet

[Guest]

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

 

[Dave Peterson]

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

 

[Guest]

Dave,

Thank you. As ou have figured out I am not all that smart on these things.
Can you tell me what a data form is and you create one.

Thanks
Keith

--
Keith Pitner
Illinois

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

 

[Dave Peterson]

Create a test worksheet in a new workbook

Put your headers in A11 (for example)
Then put some test data in A25

Select A15 (the whole range)

Click on Data (on the worksheet menu bar), then click on Form.

Dave,

Thank you. As ou have figured out I am not all that smart on these things.
Can you tell me what a data form is and you create one.

Thanks
Keith