“Unable to get the VLookup property of the WorksheetFunction Class” error [duplicate]

by

Try below code

I will recommend to use error handler while using vlookup because error might occur when the lookup_value is not found.

Private Sub ComboBox1_Change()


    On Error Resume Next
    Ret = Application.WorksheetFunction.VLookup(Me.ComboBox1.Value, Worksheets("Sheet3").Range("Names"), 2, False)
    On Error GoTo 0

    If Ret <> "" Then MsgBox Ret


End Sub

OR

 On Error Resume Next

    Result = Application.VLookup(Me.ComboBox1.Value, Worksheets("Sheet3").Range("Names"), 2, False)

    If Result = "Error 2042" Then
        'nothing found
    ElseIf cell <> Result Then
        MsgBox cell.Value
    End If

    On Error GoTo 0

More Related Contents:

  1. Excel VBA: Can’t get a match, error “Unable to get the Match property of the WorksheetFunction class”
  2. Vba Excel do vlookup from a closed file
  3. How to find the days difference between two dates [closed]
  4. Excel matching based on name date and copying data to another sheet
  5. Get all dates between 2 dates in vba
  6. Different languages issue when inserting formula from VBA
  7. vba: get unique values from array
  8. Unprotect VBProject from VB code
  9. Can VBA Reach Across Instances of Excel?
  10. Excel VBA – Delete empty rows
  11. Download attachment from Outlook and Open in Excel
  12. What is the most efficient/quickest way to loop through rows in VBA (excel)?
  13. Embed picture in outlook mail body excel vba
  14. How to check for empty array in vba macro [duplicate]
  15. Use autofilter on more than 2 criteria
  16. Compiler Error: User-defined types not defined
  17. Open a workbook using FileDialog and manipulate it in Excel VBA
  18. excel hyperlink to nothing
  19. How to add headers to a multicolumn listbox in an Excel userform using VBA
  20. How to send files via HTTP_POST with Excel using VBA?
  21. VBA to open Excel hyperlink does not work when hyperlink generated with a formula
  22. How to Add Date Picker To VBA UserForm
  23. Vba macro to copy row from table if value in table meets condition
  24. Difference between Thisworkbook.name and Activeworkbook.name in VBA
  25. Set a cell value from a function
  26. What are the differences between using the New keyword and calling CreateObject in Excel VBA?
  27. Excel VBA wildcard search
  28. How to have vba execute every 10 minutes?
  29. Read and write from/to registry in VBA
  30. Unable to read data from a CSV using ADO due to the driver thinking I am working with integers/number and showing nulls instead of text

Leave a Comment