Creat button to add row

[vishwajeet_chakravorty]

I have made a income tax calculator. In some place I have to add row manualy but I want make a button (+) in that perticular place to add row by clicking that button (+) so that more and more row can be added. How can I make this possible?

 

[JackDanIce]

Add this code to your button

Sub OneMoreRowetta ()
ActiveCell.Insert.Row
End Sub

To use, click on the cell you want to insert a row above and then click on the button

 

[lenze]

How about a DoubleClick???

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
Target.EntireRow.Insert
End Sub

lenze

 

[vishwajeet_chakravorty]

I have made the macro but it is not solving the problem. I want to make a perticulat button (+) in a fixed place and by clicking that button I may be able to go on adding rows. Write in detail that how the button having + character also.