ExcelBanter - Form for data entry

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Form for data entry (https://www.excelbanter.com/excel-discussion-misc-queries/161434-form-data-entry.html)

Lin Light

Form for data entry

Is there a way to create a form for entering data onto a spreadsheet? I know
I can in Access, but is there a way to do that in Excel?

--
Lin Light Herrick District Library

Bob I

Form for data entry

The simplest is Data, Form!

Lin Light wrote:
Is there a way to create a form for entering data onto a spreadsheet? I know
I can in Access, but is there a way to do that in Excel?

JW[_2_]

Form for data entry

Like Bob said, Excel has a built in data entry form of sorts. It is
located in Data--Form. To create your own custom form, you need to
create a UserForm in VBA and put in the necessary code to send the
values from the completed code to your worksheet.

Lin Light wrote:
Is there a way to create a form for entering data onto a spreadsheet? I know
I can in Access, but is there a way to do that in Excel?

--
Lin Light Herrick District Library

All times are GMT +1. The time now is 12:38 PM.