Garry,

I have an ActiveX ComboBox named ComboBox1 on Sheet2.

The ListFillRange property is set to a named range called "Days_List"
containing numbers only (i.e., 10, 20, 30, etc.).

The LinkedCell property is set to the name "Days".

Both the "Days" and "Days_List" names reside on Sheet2.

I'm trying to get the LinkedCell to be output as a number.

When I input the code:

With Sheet2.ComboBox1.LinkedCell = .Range("Days").Address
If IsNumeric(.Text) Then
CLng(.Text)
CInt(.Text)
CDbl(.Text)
End If
End With


... the error message below displays:

Compile error:

Invalid outside procedure


Could you tell me what I'm doing wrong ?


- Ronald K.