VBA User Form Command Button - add entry to next row - Excel 2013

Question

Hello,

I have struggled through many youtube videos trying to find the code for a command button to add an entry from a user form to an excel spreadsheet, and another command button (Close form) to close the form. Most of the online tutorials are using Excel 2010, I have the latest 2013 version of Excel however, and some things appear to be different between the Excel versions...

I know very little VBA and would appreciate some help.

Please find my form attached:

I wold like the records added to go to the 2nd row in sheet below:

Also, does anyone know how to add a time stamp to each entry? I would like another column added so that the time of entry of each form is displayed. Is this possible?...

Appreciate it!

Answer 1

I think it is easier to ammend my one to include some of the features.. Here is my form as it is now...

Well, easier is the code that you understand. You are the developer, not me. I can only make suggestions. ;-)

Have a look into this file:

https://dl.dropboxusercontent.com/u/35239054/Samples/5bef207c-9d0f-417f-b56a-cfab0ea75198.xlsm

Andreas.

Answer 2

Thank you so much Andreas! And yes, I should learn, and I will in time (VBA is however very difficult - I only know HTML and CSS).

Thank you!

Answer 3

That's because you have not included the End With that was in my code.