Hex2Dec() for VisualBasic

K

Kolob

I havn't found a way to complete this in access. I always
have to do it in excell. Please help and thanks in advance.
Kolob
 
D

Douglas J. Steele

Append &H in front of the Hex value, and use CLng to convert to a long.

Rather than HEX2DEC("A5"), you'd use CLng("&HA5")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting a cell's color based upon RGB values 6
My Visio2019 Keep Crashed when open the program 0
Monitor Screensaver Problem - Need Comand 3
Filtered view of Visio Chart 0
Loop 1
Populate a table based on check box status 2
VBA office 365 on windows 10 0
Hexadecimal to Decimal (and vice versa) 5

Top