Combo box help needed

[keranali]

Hello all I have two combo boxes which has different data I need to know how possible it is to have two of these combo boxes working together to produce a value . e.g

combo box 1 has paper types Col A
laid Paper
Text cover
Gloss Paper


Combo box 2 has Paper sizes Col B
8.5 x 11
8.5 x 14
11 x 17

Col C needs to have the cost which is dependent on changing combo box 1 and 2 e.g
If i select Laid paper and a size 8.5 x 11 the cost needs to show on col C however if I should change the size again to 11 X 17 the cost has to be updated also the same should apply if I change the paper type.


Thanks

 

[texasalynn]

how are your combo boxes created? If this a user form, from control toolbox toolbar, forms toolbar?

 

[keranali]

Thank You for your reply

I went into Developer tab in microsoft office 2007 and there you will see insert click on that and there is a form control box named combo box.



Thanks Alot

 

[texasalynn]

I don't have 2007 here to give you the steps, but if you right click on the combo box do you have a format control? If so then you cell link the box to the cell