Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Daily Dose of Excel » IsHex Function

IsHex Function

I have a need to verify some user input is hexadecimal (0-9 and A-F). Public Function IsHex(sInput As String) As Boolean         Dim lResult As Long         On Error Resume Next         lResult = CLng("&H" & sInput)             IsHex = sInput = "0" Or lResult > [...] Read More...

Read the complete post at http://www.dailydoseofexcel.com/archives/2010/03/01/ishex-function/

Posted Mar 01 2010, 05:18 PM by Daily Dose of Excel
Filed under:
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.