Put "put user form" in spreadsheet
 

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

Put "put user form" in spreadsheet
 

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

Put "put user form" in spreadsheet
 

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


"Dave Peterson" wrote:

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

Put "put user form" in spreadsheet
 

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.



Keith wrote:

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

"Dave Peterson" wrote:

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


--

Dave Peterson