New Member
July 21, 2022
I am running into the issue from the "Display All Matches..." When I copied the code to use in my workbook I run into the error of Results.Clear not being there as in your workbook. I am running Excel 2016 any work around or fix I can do to fix this issue. I discovered that the reference is F3Dynamic... which is not with my workbook. Any help could be useful. Thank you.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
New Member
July 21, 2022
Not sure how to add a sample. But here is the code I am running Office 2016 and it is not recognizing the Results.Clear. When I pasted his code into my workbook and adjusted for my workbook it halts at that code. with an error. when I looked at the object browser of it in my workbook there is no reference. When I looked in Philip Treacy downloaded workbook the refrence show F3 Dynamic Library. I cannot find it in my workbook.
Option Explicit
' Written by Philip Treacy
' Display All Matches from Search in Userform ListBox
'
Dim FormEvents As Boolean
Private Sub ClearForm(Except As String)
' Clears the list box and text boxes EXCEPT the text box
' currently having data entered into it
Select Case Except
Case "FName"
FormEvents = False
LName.Value = ""
Location.Value = ""
Department.Value = ""
Results.Clear
FormEvents = True
Case "LName"
FormEvents = False
FName.Value = ""
Location.Value = ""
Department.Value = ""
Results.Clear
FormEvents = True
Case "Location"
FormEvents = False
FName.Value = ""
LName.Value = ""
Department.Value = ""
Results.Clear
FormEvents = True
Case "Department"
FormEvents = False
FName.Value = ""
LName.Value = ""
Location.Value = ""
Results.Clear
FormEvents = True
Case Else
FormEvents = False
FName.Value = ""
LName.Value = ""
Location.Value = ""
Department.Value = ""
Results.Clear
FormEvents = True
End Select
End Sub
1 Guest(s)