Hi,

I've recently constructed a spreadsheet which makes a simple calculation when a component is selected, It works perfectly
but I've been asked to supply another department. However, to do that its apparent that something in VBA will
be alot more suitable and stable.

So, I've compiled a combo box with a list of items which determines my variance in the calculation.
The Combo box has (currently) 3 variables in the box:
C05093 = which equals 50
C05094 = which equals 53
C05095 = which equals 55

Therefore, the calculation is:

Team Size - C05095 - offset = 1235mm
1300mm - 50mm - 10mm = 1235mm

The variable part is the pull down menu of C05095.

Any advice?