Insert data into a new row through a userform - Excelvba

Question

As the title suggests I am trying to add data into a new row through a userform. The problem I am having is that the layout out is as such:

Title Jan feb mar apr may jun jul aug sep oct nov dec Total income (Here needs to be where the data is inserted) Outgoing (again, another set of data needs to be added here)

What is the code to achieve this as currently it is going below outgoing but I want it in between income and outgoing

I am happy to discuss if you need more information.

Thanks in advance

Answer 1

You provided too little details with what you are exactly struggling. I can suggest the following: 1. Create a UserForm with as the columns as textboxes. 2. Add a button to the UserForm. When clicked find the last row in the worksheet (http://www.ozgrid.com/VBA/ExcelRanges.htm) and insert the values from each textbox.

Here are some links to get you started:

1. UserForms: http://www.excel-easy.com/vba/userform.html
2. Manipulating cells: http://msdn.microsoft.com/en-us/library/office/ff838238(v=office.15).aspx