(Solved) – Old VBA Code I’m trying to run on 2010 64Bit get error on declare to add PrtSafe

'Author       : Jim Neely
'Macro Purpose: To populate a listbox with data from
'               a worksheet range

' Dim variables up here so that they are available to the entire form
Dim str1 As String, str2 As String, str3 As String, str4 As String, str5 As String, str6 As String, str7 As Integer
Dim lbtarget As MSForms.ListBox
Dim lb2Cap As String
Dim lb3Cap As String
Dim BgnMo As String
Dim EndMo As String
Dim wsht As String
Dim Res As Variant
Dim rngSource As Range
Dim Cabinet, Drawer, CHeight As String
Dim i As Integer
Option Explicit

Private Declare PrtSafe Sub keybd_event Lib "user32" (ByVal bVk As Byte, _
    ByVal bScan As Byte, ByVal dwFlags As Long, ByVal dwExtraInfo As Long)

Above is one of several declared statements in my project. all get tag error. any ideas on how to fix this???

Leave a Reply

Your email address will not be published. Required fields are marked *