If I have an hexadecimal number as in 8 places e.g. 8E00AD01,
I want it converted into binary which will display as 32 bits using VBA

Simply convert each hex digit into a 4-bit string. Pretty easy in using standard Excel formulas. Or you can use the "hex2bin" Excel function. Not sure about doing it in VBA.