List Box
 

Can I use values from a list box/combo box in a formula and if so how do I
do that?
TIA

List Box
 

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

List Box
 

Thanks, that did it.
M

"John Green" wrote in message
...
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