Convert Hex to Number

[Tony]

I know how to Convert a Number to Hex, but I cannot find
how to convert a Hex Field to a Number.

MyNum = 170
MyChar = Hex(MyNum) will give me a AA answer which is
correct, but how do I convert "AF" to a number?

Thank You in Advance

Tony

 

[Tim Ferguson]

I know how to Convert a Number to Hex, but I cannot find
how to convert a Hex Field to a Number.

MyNum = 170
MyChar = Hex(MyNum) will give me a AA answer which is
correct, but how do I convert "AF" to a number?

dwMyLong = CLng("&H" & strMyChar)

HTH


Tim F