Decimal to Hex 2

[sacsac]

I know that it's easy to convert a decimal value to Hex using:

HexValue = Hex(DecimalValue)

That's fine, until I have a very large decimal value like:

123456789877754 (which is basically of DataType Variant, with a CDec conversion)

This causes an overflow when trying to convert to Hex.

I've trawled through various threads, which seem to mainly deal with the issues of Hex to Decimal (and which I have under control!)

Any ideas?

 

[strongm]

(although it should now become clearer why I went with a version that didn't require maths ...)