[RESOLVED] How to Add Row (VBA Excel)..pls help

[zach007]

Dear Experts,

I am trying to make an invoice or PO form with Excel VBA....I have "No", "Item No"(combobox), "Description", "Unit Price", "Qty" and "Total" and an "Add Row" button...(these are on row 1 from the left to the right A,B,C,D,E and F)

What am I trying to do is, when I click on "Add Row" button, THEN it will add the next number for "No", and add existing "Item No" as combobox with the same value, etc.....(in the second row, etc)....

What codes should I put into this please..????

I attach the file to make it clear and for your reviews

Thank you very much for your kind helps..

[thelocaluk]

Heres a quicky.

[zach007]

Hi,

Thanks a lot...I just want to ask more if you dont mind...

1. How to calculate the Grand Total please..??
2. and, how to add row to the next row without skipping one row please?

Thanks a lot..

[thelocaluk]

My mistake, heres what you asked for though