Dialog Box, Form, or Macro that Adds Rows of Data to the End of an Excel Table

[Chrisdudley7]

I have a spreadsheet in which I need to create a dialog box, form, or field-entry box for simple end-user data entry that automatically adds entries to the bottom of a table. My end-users are very inexperienced using excel and I want to design something for them that makes for simple data entry and minimal searching. Ideally, this would be a popup box that presents as soon as the workbook is opened and therefore minimizes the chances that they might disrupt the archived data in the spreadsheet.

On my end, I added a button to my Quick Access toolbar called ‘Forms…’ that automatically creates fields that correspond with the available cells. This is similar to what I am hoping to achieve and maybe a simple macro that pops open the field entry box when they start the macro-enabled workbook would suffice. I feel like this must be a fairly basic function in excel that is not immediately obvious to me (e.g. like the letter template dialog box that punches return/sender addresses into a printable document)

I have a screenshot and a sample worksheet that will help explain what I am going for, though I don’t see a way to attach it here.

Any help you guys can offer is greatly appreciated. I have always had great experiences on Mr. Excel.

 

[sijpie]

To show screenshots, save your screenshot on a photosharing site and put the link in your mail. Same if you want to share a workbook.

There is the simplest of input devices called InputBox

dim vA as variable
vA = application.Inputbox("Enter date for new sheet", "Enter Date")

This is useful if you just need one item from the user.

Else you would construct a userform with all the fields and explanation of the input required, and then some code to be carried out when the user presses the OK button.

you can write protect the worksheet so the user cannot change anything there, with a button on the sheet to call the userform, and/or call theuserform or inputbox from the workbook_open sub.
To make it fool proof requires a bit of work and logic. What happens when the user cancels what happens when he closes the form, etc, etc

 

[Chrisdudley7]

This works, thanks for your help!