Put "put user form" in spreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Keith - 08 Apr 2007 16:32 GMT

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

Signature

Keith Pitner
Illinois

Reply to this Message

Dave Peterson - 08 Apr 2007 17:33 GMT

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

> Hi all,
>
[quoted text clipped - 20 lines]
> Keith Pitner
> Illinois

Signature

Dave Peterson

Reply to this Message

Keith - 08 Apr 2007 18:22 GMT

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

Signature

Keith Pitner
Illinois

> You may not need a userfrom--maybe Data|Form would be sufficient.
>
[quoted text clipped - 25 lines]
> > Keith Pitner
> > Illinois

Reply to this Message

Dave Peterson - 08 Apr 2007 19:00 GMT

Create a test worksheet in a new workbook

Put your headers in A1:D1 (for example)
Then put some test data in A2:D5

Select A1:D5 (the whole range)

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

> Dave,
>
[quoted text clipped - 41 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message