Declare Function RegisterWindowMessage

[dkubly]

Getting an error in the following code...

Private Declare Function RegisterWindowMessage Lib "user32" Alias "RegisterWindowMessageA" (ByVal lpString As String) As Long

Error message = "The code in this project must be updated for use on 64-bit system... PtrSafe attribute

[zmbd]

- You need to specify what environment you are working it.
- The error is fairly specific, you have not declared the code as safe to run in the 64Bit environment " PtrSafe "

Microsoft Article: "Compile error: The code in this project must be updated for use on 64-bit systems"

The crux of the solution given is to use the conditional compiler such as:

#If VBA7 Then
    Private Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal ms As LongPtr)
#Else
    Private Declare Sub Sleep Lib "kernel32" (ByVal ms as Long)
#End If

and in each Declare statement you have to change the name of any parameter that is passed from "ms" to "millisecs. "