d or D as numeric? 1

[claudehenri]

Hi

I was woundering about the letter "d" in a text box. I have a condition IsNumeric(textboxX)and for some reason "d" or "D" is treated as numeric "e" and "E" are as well but this is understandable (being for exponent). No other letters cause this. Does "d" have some significance I don't know about?

Claude-Henri

 

[byundt]

I'm not reproducing your problem, but the letters A, B, C, D, E and F stand for the hexadecimal digits equivalent to 11 through 15. So the number 62 would be represented as 3E in base 16 (hexadecimal).

 

[fumei]

Could you post more detail, with some code?

Gerry

 

[claudehenri]

yes I know about hex, but a, b, c, f don't give the same effect! (as i stated NO other letters cause this)

here's the basic code

Private Sub TextBox22_Exit(ByVal Cancel As MSForms.ReturnBoolean)

If IsNumeric(TextBox22.Value) Then
Worksheets(WorkSheetName).Cells(Temp, 2) = TextBox22.Value
Else
MsgBox "Enter numeric values"
Cancel = True
End If

Claude-Henri

 

[TonyJollans]

Hi Claude-Henri,

I'm not sure there are any circumstances where you could tell the difference, and I guess it's supported for compatibility reasons, but "D" is used instead of "E" to represent double precision in exponential representation. As far as I know there are no other letters used as part of (decimal) numbers in VBA.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

 

[claudehenri]

Thanks

Just wanted to make sure it wouldn't send my formulas haywire

Claude-Henri