excel userforms created with a 32 bit machine not loading on a 64 bit machine

You need to re-write to suit 64 bit (API declarations etc) and some controls (TreeView, ListView, Calendar and others) are simply not available on 64 Bit.