I have a combo box and it is linked to cells in the worksheet that do
calculations.

I have three input boxes in the combo box, there is a fourth box that is the
result of the three other boxes.

So when values are entered into the three boxes the 4th box looks up a range
in the worksheet which is the answer I want.

The problem is that the answer only shows up in the 4th box when I click on
the box and type in something, then the number appears. Is there anyway to
refresh the combobox when I click on "OK" box or some other box.


It would be a lot cleaner if the number appeared automatcially or was
refreshed somehow.

Thanks