'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???