You can specify a worksheet cell in the LinkedCell property of the box,
Sheet1!C1 for example. Now C1 will display the value selected in the box you
can use C1 in your calculations.

--
John Green
Sydney
Australia


"Mike Cramsey" wrote in message
...
Can I use values from a list box/combo box in a formula and if so how do I
do that?
TIA