Userform Solution?

[tintin102]

Hi I am trying to create an all in one account/ordering system for my online store. I am trying to add userforms to make it easier however I am wondering if it is possible to do the following

I have a order tab where I keep a record of the orders, what items where ordered, price qty etc. Now I have the titles as show below. In the userform currently I can add 1 product at a time, but th eproblem comes when a customer orders a number of different items, I have to enter in each item seperatly, does anyone know how i can have a "add another item" button which would allow me to addd another field in order to add another item to the order.

Please let me know if you need any more info on the problem

Kind Regards

Toby

 

[Norie]

Toby

If you just need to clear the userform after an item has been added:

Unload Me
 
UserForm1.Show

Or do you want to keep the values in some fields, eg OrderID, InvoiceID, and just add another item.

 

[tintin102]

The easist way of explianing it

I get an order

2xM4 Magazines
2 Ak Magazines

I go into excel click add new order
then the userform pops up-

However I need more than one field due to ther being more than 1 product id's

so something like this click on the add another item and a new field pops up allowing me to enter in a new product.

I dont mind if there is a simpler way of doing this type of thing or not but I am stuck on what code to use

Kind Regards

Toby

 

[dannac]

I made a user form for to use as a check register/balance.

You can take a look and get ideas from it and view the code.

Only approx 50 kb file size.

Send me a PM and I can email to you.

 

[Norie]

You can use a listbox to list the items.

The Add Item button could simply add to that list.

Then when you are finished the data from the listbox can easily be transferred to the spreadsheet.

One thing I don't understand is the InvoiceID and OrderNo, they don't have any value on the worksheet you posted or in on the userform.

Anyway, here's a workbook with a simple example.

http://www.box.net/shared/txq9fzz0r9ccsdb2xv65

 

[tintin102]

whoops I missed them out they are produced by my shopping cart when an order is placed so what you have done is fine. Thankyou very much, how did you learn VB by the way as I wanto to be able to make user forms myself

Kind Regards

Toby

 

[Norie]

Toby

Do you mean the IDs are produced/generated by the shopping cart?

 

[tintin102]

Yeah both the invoice and order ID are produced by the shopping cart so