automatic data entry form

Question

automatic data entry form

Anonymous

Good morning,

I have a requirement to create a data entry form for a pretty straight forward excel table (3,000 rows, 20 columns). I was able to quickly use the Forms capability native to excel and it popped up the data entry form just as I want it. My question: is there any way to make that a "permanent" form that can be moved to another sheet?

I am trying to make the update process very easy for people who are not very computer literate. my approach would be to have the form with some instructions on one tab and the actual table in another.

Is there a way to do that with that auto data entry form, or do I have to create a userform using VBA (which I have not done in about 15 years)?

Any Help would be appreciated. I am using Office 2016.

Jim

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

HansV 462.6K

You can create macro that displays the built-in data form for any sheet.

Let's say that your data are on a sheet named Sheet1.

The macro would look like this:

Sub DisplayForm()

Worksheets("Sheet1").ShowDataForm

End Sub

On another worksheet, you can create a Forms command button that executes this macro.

Or you can add a button to the Quick Access Toolbar that runs the macro. Make sure to specify that the QAT button will be stored with the workbook.

0 comments

2 additional answers

Answer 1

Anonymous

Hans, works great! thanks for taking the time to help.

Regards,

Jim

0 comments

Answer 2

Anonymous

Thank you, Hans! I will try this this afternoon and mark the thread answered.

Jim

0 comments

Share via

automatic data entry form

2 additional answers