Shopping cart

[fencer]

Hello,

I am just begginer with vba and I need help with off-line shopping cart.
I created small db of my products in new sheet, and I created shopping sheets aswell, where you select wanted amount by using spinbutton. I think that I have to create new sheet for cart. So, I need help on automatic shopping cart:

1.What to do, to avoid empty rows after I decide to change my desired item's quantity back to 0. ( You want to buy 1st, 2nd and 3rd items, but later decide to cancel purchase of 2nd)

2.How to put product's details on one row down from previously added one.

 

[chobeo31]

In your case, I think there is no necessity for VBA but only when your want to use userform to input data and use the spinbutton.
I have 2 methods:
(1) Using only excel to input data, using VLOOKUP for the price and other factors of the product, then process to output (total price, I guess)
(2) Using userform to input data, 1 combobox for the product you want to buy, 1 textbox for the quantity you have, 1 button that record the product and quantity into new blanked sheet (shopping cart), 1 button to print out shoppng cart as well as the total price
Think about that.