Converting a hex value contained in a string to integer 1

[adi316]

Hi. I have a string which contains a hex value. I want to somehow convert this value to an int. how is it possible? TIA

 

[jojo11]

You can use the Val function:

Dim l As Long
Dim sHex As String

sHex = "A0"
l = CLng("&H" & sHex)

The leading "&H" tells Val that your value is in hexadecimal.