Hex to Decimal (VBA/Excel/XP)

Topic

New Reply

I want to convert Hex values to Decimal in VBA. The builtin function HEX2DEC apparently does not work inside a module. Example change EE to 238

Reply | Quote

Replies

I noticed that VBA has Hex(), Hex$(), Oct() and Oct$() functions. Seems they forgot about going the other direction.

Reply | Quote

There is probably no need as x = &HFF will assign the value 255 to x. The Bin, Oct & Hex functions just return an appropriate string representation of the value passed to them.

Andrew

Reply | Quote

There is probably no need as x = &HFF will assign the value 255 to x. The Bin, Oct & Hex functions just return an appropriate string representation of the value passed to them.

Andrew

Reply | Quote

Say that your hex value is stored in a variable strHex.

CLng(“&H” & strHex)

will yield the decimal value. So you can create your own Hex2Dec:

Function Hex2Dec(HexVal As Variant) As Variant
Hex2Dec = “”
On Error Resume Next
Hex2Dec = CLng(“&H” & strHex)
End Function

This function will return a blank if the input is not a valid hex string. If you’d rather return 0 or Null, change the second line accordingly.

Reply | Quote

Say that your hex value is stored in a variable strHex.

CLng(“&H” & strHex)

will yield the decimal value. So you can create your own Hex2Dec:

Function Hex2Dec(HexVal As Variant) As Variant
Hex2Dec = “”
On Error Resume Next
Hex2Dec = CLng(“&H” & strHex)
End Function

This function will return a blank if the input is not a valid hex string. If you’d rather return 0 or Null, change the second line accordingly.

Reply | Quote

CDec() works as well:

?hex(1234)
4D2
?cdec(&H4D2)
1234 

(From the Immediate window)

Reply | Quote

It will, but (a) VBA does not support variables of type decimal, so you might as well use CLng, and ( you still have to prefix the value with &H. CDec doesn’t recognize a hex string such as 3F by itself.

Reply | Quote

Clng is a great instruction. Some idiot set this machine up without help.

Reply | Quote

Clng is a great instruction. Some idiot set this machine up without help.

Reply | Quote

It will, but (a) VBA does not support variables of type decimal, so you might as well use CLng, and ( you still have to prefix the value with &H. CDec doesn’t recognize a hex string such as 3F by itself.

Reply | Quote

CDec() works as well:

?hex(1234)
4D2
?cdec(&H4D2)
1234 

(From the Immediate window)

Reply | Quote