Help - want macro form to populate spreadsheet

Mar 14th, 2002, 12:31 PM

Please forgive me, I'm new. I'm building a spreadsheet with 8 columns of information. I'm very comfortable in Excel, but have never worked with macros. Someone else, who is computer illiterate, needs to be able to add data to my spreadsheet.

Ideally, what I want is a form, so this person can enter all the data into text boxes. When they hit enter I want each column of the next blank row to be populated. This person can then use the form again to enter the next row. Can this be done?

I hope this makes some sense.
Thanks, -M

Al Chara · Mar 14th, 2002, 12:37 PM

This can be done. Read the help files on userforms.

Mudface · Mar 14th, 2002, 12:39 PM

Try selecting the first cell (preferably with a column heading) in your data and clicking on Data-Form. This gives you the option of reviewing your data and adding data to the next row. This might be an easier option than creating a userform

.

Mar 14th, 2002, 02:34 PM

Mudface - thanks for the tip. Unfortuately, I'm afraid it give the other user too much ability to screw things up. I'm still looking for help on how to do this - please see my original post. I've tried to find tips on useforms, and cannot find the info I'm looking for.

I would appreciate any real help.

-M

Al Chara · Mar 14th, 2002, 02:41 PM

The simplest way for you to do what you is to add the amount of textboxes that you want to the userform with a label for each describing what should be entered into the textbox. Then have a command button to enter the data into the next empty column. If you send me some sample data then I can create a basic userform for you.

Hope this helps.
Kind regards, Al.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 12:31 PM	#1
Guest Posts: n/a	Please forgive me, I'm new. I'm building a spreadsheet with 8 columns of information. I'm very comfortable in Excel, but have never worked with macros. Someone else, who is computer illiterate, needs to be able to add data to my spreadsheet. Ideally, what I want is a form, so this person can enter all the data into text boxes. When they hit enter I want each column of the next blank row to be populated. This person can then use the form again to enter the next row. Can this be done? I hope this makes some sense. Thanks, -M

Mar 14th, 2002, 12:37 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	This can be done. Read the help files on userforms.

Mar 14th, 2002, 12:39 PM	#3
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Try selecting the first cell (preferably with a column heading) in your data and clicking on Data-Form. This gives you the option of reviewing your data and adding data to the next row. This might be an easier option than creating a userform .

Mar 14th, 2002, 02:34 PM	#4
Guest Posts: n/a	Mudface - thanks for the tip. Unfortuately, I'm afraid it give the other user too much ability to screw things up. I'm still looking for help on how to do this - please see my original post. I've tried to find tips on useforms, and cannot find the info I'm looking for. I would appreciate any real help. -M

Mar 14th, 2002, 02:41 PM	#5
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	The simplest way for you to do what you is to add the amount of textboxes that you want to the userform with a label for each describing what should be entered into the textbox. Then have a command button to enter the data into the next empty column. If you send me some sample data then I can create a basic userform for you. Hope this helps. Kind regards, Al.