Using a spreadsheet for data entry in a user form

[johannes2008]

Hello All

What I currently have is a spread sheet where users enter an indeterminate number of data points down column a with each point having 4 fields going across the row. However the sheet I am using also shows the results in the same sheet and this makes it all quite bulky to use.

What I would like to do is streamline the process by having the user only use and see userforms. What I want to do is create a user form that would allow users to enter the data in a "mini-spreadsheet" that when the click next the data would then populate the actual spread sheet. Does anyone know how to best go about doing this?

Thanks for the help
-Johannes

 

[Gary McMaster]

There's a built in form that may suit your needs.

http://www.timeatlas.com/5_minute_tips/general/excel_data_form_makes_input_easier

Gary

 

[johannes2008]

Hey Gary

Thanks for the reply. While the link you gave me was something along the lines of what I was looking for. What I am hoping to do is create something where the user never sees the main spreadsheet where all the input data is and calculations are done. So a userform that also shows the entries on the userform as they are entered.

Thanks for the help
-Johannes

 

[Gary McMaster]

Here's another one:

http://www.contextures.com/xlForm02.html

As far as I know, there will be no way (from within Excel / VBA) to display a user form without a worksheet showing. You may be able to make the form large enough to hide the sheet behind it or have the form place the data on a hidden sheet but I believe you will need an active sheet.

Gary