Atlanta Custom Software Development 

   Search        Code/Page

User Login



Forgot the Password?
» Web Development
» Maintenance
» Data Integration/BI
» Information Management
» Regular Expr Tester
» Free Tools

Convert Hexadecimal numbers
[ All Languages » VB »  Math]

Total Hit ( 3357)

Rate this article:     Poor     Excellent 

 Submit Your Question/Comment about this article



While Visual Basic offers the Hex$ function that converts a decimal value into its hexadecimal equivalent number, it seems that the inverse function is missing. Not true. Try out this one-liner:

Click here to copy the following block
Function HexToDec(HexValue As String) As Long
  HexToDec = Val("&H" & HexValue)
End Function

UPDATE The code in the original tip always tries to return an Integer value, which means that, for example, "FFFF" is converted to -1 instead of 65,535. The following new versions fixes this behavior, while still giving you the capability to convert to an integer:

Click here to copy the following block
Function HexToDec(HexValue As String, Optional ToInteger As Boolean) As Long
  If ToInteger Then
    ' convert to an integer value, if possible.
    ' Use CInt() if you want to *always* convert to an Integer
    HexToDec = Val("&H" & HexValue)
    ' always convert to a Long. You can also use the CLng() function.
    HexToDec = Val("&H" & HexValue & "&")
  End If
End Function

Submitted By : Nayan Patel  (Member Since : 5/26/2004 12:23:06 PM)

Job Description : He is the moderator of this site and currently working as an independent consultant. He works with, SQL Server and other MS technologies. He is, MCDBA and MCSE. In his free time he likes to watch funny movies and doing oil painting.
View all (893) submissions by this author  (Birth Date : 7/14/1981 )

Home   |  Comment   |  Contact Us   |  Privacy Policy   |  Terms & Conditions   |  BlogsZappySys

© 2008 BinaryWorld LLC. All rights reserved.