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

hi guys i wrote a program for a school project on a 32 bit machine some years ago and now i have upgraded to a 64 bit machine and the userforms no longer loads. i keep getting a message that reads "Could not load objects because they are not available on this machine." Can anyone help me out on this issue? i have attached pictures.

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.

when you try to run the file there should be lines of code that are in red such as the following. There will be likely more than one line of code in red.

1. Public Declare Function SetTimer Lib "user32" (ByVal hwnd As Long, ByVal nIDEvent As Long, ByVal uElapse As Long, ByVal lpTimerFunc As Long) As Long


You must type "PtrSafe" before the word "Fuction" in each line of code so the line of code looks like this.

1. Public Declare PtrSafe Function SetTimer Lib "user32" (ByVal hwnd As Long, ByVal nIDEvent As Long, ByVal uElapse As Long, ByVal lpTimerFunc As Long) As Long

With respect - the suggested changes are not correct. Parameters which are Window Handles must use the LONGPTR variable type, otherwise results from the Function could be incorrect.

I'm not going to explain - it's something the OP needs to understand rather than blindly using code that potentially could crash Excel: https://msdn.microsoft.com/en-us/lib.../gg264421.aspx

"PtrSafe" worked for me. It solved my 32bit to 64 bit problems. all files work fine now. Excel has not crashed.

OK.

Feel free to ignore the comments on the page I linked: "The problem with running legacy VBA code in 64-bit Office is that trying to load 64-bits into a 32-bit data type truncates the 64-bit quantity. This can result in memory overruns, unexpected results in your code, and possible application failure".

Much like my comment to the OP I would respectfully suggest you should read and make sure you understand the contents of that page.

hey guys i've done both i've used the ptrsafe and the longptr and they work but the main problem i'm having is that it seems as though all those userform objects/controls(e.g progress bar) that i've used are no longer available in 64 bit because im still getting the message saying "Could not load objects because they are not available on this machine". Everything is working perfectly on my 32 bit machine.