Guide to creating an Excel Order Form

Hi all! I am teaching myself VBA because I have been given the task of creating an order form in Excel. I dont need to know anything about the layout etc, just the functionality. I have two drop down lists on the order form which get their data from two lists on another sheet and they are the Product name and the Colour. The requirements are thus:

Allow the user to;
Select the product and colour from drop downs (raw data is on 'Data' sheet)
Enter the quantity
Click the add button that will
Add the order to the list below and sort by product code
Add in the FORMULA TO CALCULATE THE TOTAL (PRICE x QUANTITY)
Have the total formula update to allow for the new item
have the Clear all button to clear all the orders
Code the Delete the selected Order button

I'm not asking for the code, I just need a rough guide as to how I would approach this i.e. step 1) Create sub procedure to do X step 2) create macro for button to do this etc etc.

I am learning fast so you don't need to be concerned that this is too difficult for me, once I get the hang of it after this example I will understand it fully as I'm reading some text books on it too. So no comments like "dont bother trying" or "stick to basic examples first" please.

Thank you kindly!

Originally Posted by XeRo Solus

Welcome to the Forum. Are you going to use a Excel userform or will you be placing the controls directly on your spreadsheet?

I'll put them directly onto the sheet like:

1) PRODUCT SELECT: User selects from drop down and when ADD is clicked, the record inserts into the next available line in ORDER TOTALS (2)

--------------------------------------------------------
| DropProduct | DropColour | Qty? || ADD |
--------------------------------------------------------

2) ORDER TOTALS

--------------------------------------------------
| Product | Colour | Qty | Price |
--------------------------------------------------
Record 1
---------------------------------------------------
Record 2
---------------------------------------------------
Record 3
---------------------------------------------------



Total = ________