Combo Box of Control Toolbox

Hi all,

I am now using Excel 2003 and try to return numerical value from Combo Box of Control Toolbox, which I need to use in other formulas. But I keep getting string from it. Could anyone help me out? I don't want to use Combo Box from Forms because I need extra features of Control Toolbox. Thanks in advance.

Dreamchaser

How did you populate the choices for your control?

"Dreamchaser" wrote:

>
> Hi all,
>
> I am now using Excel 2003 and try to return numerical value from Combo
> Box of Control Toolbox, which I need to use in other formulas. But I
> keep getting string from it. Could anyone help me out? I don't want to
> use Combo Box from Forms because I need extra features of Control
> Toolbox. Thanks in advance.
>
> Dreamchaser
>
>
> --
> Dreamchaser
> ------------------------------------------------------------------------
> Dreamchaser's Profile: http://www.excelforum.com/member.php...o&userid=27454
> View this thread: http://www.excelforum.com/showthread...hreadid=469657
>
>

I populated combo box with a list of strings. But I want it to return numerical values instead of strings. We know it is not an issur for combo box from Form. Any hints? Thanks.