Check Box that shows options in Combo Box if Checked, and Hides if Not Checked

I'm stuck on a User Form Excel 2007 that I have no idea how to make! (For a project)

I have 2 check boxes with the Phone Brand names (Apple,Samsung), I wanted these to Show options of corresponding models in a Combo Box.

Example: Apple Checked Combo Box Shows (Apple 5C, Apple 5S, Apple 4)
Samsung NOT Checked so Combo Box Hides (Samsung Galaxy Note 2, Ace and Ace 2)

Furthermore depending on what brand of phone I choose and then model, I would like it to input the price into a cell, in order to calculate a final bill. (Taking information from a table).

Anyone got any idea's?! Iv'e never used VBA before and I have been pulling my hair out for days!

Hi Jodie,

Save that hair!

Here's a quick take on a form that may meet your needs. (It only identifies the requirements that you have specified).
Open up the spreadsheet, and press Alt+F11, to bring up the VBA environment. Doble-click on UserFOrm1 (on the left hand side, in the folder called forms), and press F5.

As you choose different combinations (4 of them) of manufacturers, you'll see the criteria that will be used to load the phone.

Note:

This model allows you to choose either or both or none, because you didn't indicate that the selection was mutually exclusive.

Let me know if this gives you any ideas (it is very simple code, and you should be able to understand it just be looking at it), and then get back to us!

HTH

Tony

Hello Tony,
Haha
I do understand it, just tested it, it doesn't load the models, also the price bar isn't needed... but more like once I select a phone "Apple 5s" and press okay, it inputs the model chosen and the corresponding price into a cell in the spreadsheet which then calculates a total bill.

Thanks,
Jodie

Hi Jodie

Well, it was only a starting point The main issue was whether or not you wanted to allow both manufacturers to be selected.

I've updated it to do most of what you want (have to leave something for you to get paid for, right!), so take another look and let me know.

This will allow you (with a couple of tweaks) to put the price (and the description) into an invoice line. However, you don't mention where that invoice line is, so I can't really do that bit for you.

HTH
Tony

PS How's the weather in London?