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

What code do you have as of now? (StackOverflow does not code entire solutions for you - it helps you with issues) — AnalystCave.com
– AnalystCave.com, Commented Oct 1, 2014 at 12:06

AnalystCave.com · Accepted Answer · 2014-10-01 12:15:29Z

2

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:

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

answered Oct 1, 2014 at 12:15

AnalystCave.com

5,1242 gold badges25 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

StackUser2014 Over a year ago

the part I am struggling with is getting the button to insert a new row always at A2 (for example) and then again 1 row above the last row in the work sheet.

AnalystCave.com Over a year ago

Add a new row at A2 - Range("A2").EntireRow.Insert Shift:=xlDown. If you want to add a row 1 row above the last in the worksheet Range("A1").End(xlDown).EntireRow.Insert Shift:=xlDown (where A1 is the first cell in the worksheet from which you will be searching down for the first empty cell)

Collectives™ on Stack Overflow

Insert data into a new row through a userform - Excelvba

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related