Combo Box of Control Toolbox
 

Hi all,

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

Dreamchase

--
Dreamchase
-----------------------------------------------------------------------
Dreamchaser's Profile: http://www.excelforum.com/member.php...fo&userid=2745
View this thread: http://www.excelforum.com/showthread.php?threadid=46965

Combo Box of Control Toolbox
 

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

Combo Box of Control Toolbox
 

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.


--
Dreamchaser
------------------------------------------------------------------------
Dreamchaser's Profile: http://www.excelforum.com/member.php...o&userid=27454
View this thread: http://www.excelforum.com/showthread...hreadid=469657