Forms in Excel

RobK · Mar 30th, 2004, 05:01 PM

Sorry for the simple question ... it is probably something taught in Excel 101, but I am at a loss.

Suppose I use an Excel worksheet (protected sheet, conditional formatting etc) as a user form. How do I:

a) place the entered information as a record in the last row of a database on a separate sheet?
b) allow the user to continue to subsequently enter new records (reset the form and continue to add records until finished?

Smitty · Mar 30th, 2004, 06:15 PM

The simplest way is to use Excel's built in Data Form. Goto Data-->Form. It will automatically map your range of up to 34 fields. You Tab through the fields and hitting enter will automatically append the data to the last row.

To call the Form from a button is pretty simple: ActiveSheet.ShowDataForm

Hope that helps,

Smitty

Mar 30th, 2004, 05:01 PM	#1
RobK Join Date: Mar 2004 Posts: 21	Forms in Excel Sorry for the simple question ... it is probably something taught in Excel 101, but I am at a loss. Suppose I use an Excel worksheet (protected sheet, conditional formatting etc) as a user form. How do I: a) place the entered information as a record in the last row of a database on a separate sheet? b) allow the user to continue to subsequently enter new records (reset the form and continue to add records until finished?

Mar 30th, 2004, 06:15 PM	#2
Smitty MrExcel MVP Moderator Join Date: May 2003 Location: Boulder Creek, CA Posts: 18,775	Re: Forms in Excel The simplest way is to use Excel's built in Data Form. Goto Data-->Form. It will automatically map your range of up to 34 fields. You Tab through the fields and hitting enter will automatically append the data to the last row. To call the Form from a button is pretty simple: ActiveSheet.ShowDataForm Hope that helps, Smitty

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