How To access the convert to numbers funtion in VBA

[counterindigo]

In excel when a number is stored as text, excel has a function to convert it to numbers that is accessed by the error checking function. I tried to use the macro recorder to discover how to call it, but this didn't work. Any ideas how to access this method via VBA?

Thank you,

Michael

 

[shg]

Welcome to the board.

    With Range("A1")
        If IsNumeric(.Value2) And VarType(.Value2) = vbString Then
            ' it's a number stored as text
        End If
    End With

 

[counterindigo]

Thanks for the reply.

I probably wasn't clear enough with my question. When text is stored as a number on a spreadsheet, it puts a little green triangle in the upper left corner of the cell. If you click on that cell it brings up a little menu. One of the options it "Convert to Number". I know how to write code to convert strings to numbers, but what I'd like to know is how to access the method that excel uses to do the conversion.

Thanks,

Michael

 

[shg]

I don't believe it's exposed; it's a UI thing, and easy to do in code without using a method.

 

[counterindigo]

If it isn't exposed, that explains why I can't find it.

Thank you!