Check if value exists in column in VBA

by

The find method of a range is faster than using a for loop to loop through all the cells manually.

here is an example of using the find method in vba

Sub Find_First()
Dim FindString As String
Dim Rng As Range
FindString = InputBox("Enter a Search value")
If Trim(FindString) <> "" Then
    With Sheets("Sheet1").Range("A:A") 'searches all of column A
        Set Rng = .Find(What:=FindString, _
                        After:=.Cells(.Cells.Count), _
                        LookIn:=xlValues, _
                        LookAt:=xlWhole, _
                        SearchOrder:=xlByRows, _
                        SearchDirection:=xlNext, _
                        MatchCase:=False)
        If Not Rng Is Nothing Then
            Application.Goto Rng, True 'value found
        Else
            MsgBox "Nothing found" 'value not found
        End If
    End With
End If
End Sub

More Related Contents:

  1. How do you change the value of a cell in excel by clicking on it using VBA? [closed]
  2. How to avoid using Select in Excel VBA
  3. How do I use FileSystemObject in VBA?
  4. Convert Text to Date?
  5. Run Excel Macro from Outside Excel Using VBScript From Command Line
  6. Importing text file into excel sheet
  7. Loop through each cell in a range of cells when given a Range object
  8. Checking for #N/A in Excel cell from VBA code
  9. Non-web SQL Injection
  10. Error: “Could Not Find Installable ISAM”
  11. Filling any empty cells with the value above
  12. Is there a way to slow down a Web Scraper so it will pick up the code?
  13. Create a folder and sub folder in Excel VBA
  14. hiding formulas in formula bar
  15. How to delete multiple rows without a loop in Excel VBA
  16. Excel vba to create every possible combination of a Range
  17. VBA Many buttons point to the same _Click sub
  18. How to suppress Update Links warning?
  19. How do we use restful APIs from Excel macros (vba)?
  20. Run a Macro from Another Workbook
  21. Sorting a dictionary by key in VBA
  22. VBA paste as values – how to
  23. What are the benefits of using Classes in VBA? [closed]
  24. Writing a VLOOKUP function in vba
  25. Generate Word Documents (in Excel VBA) from a series of Document Templates
  26. Handle cancellation of InputBox to select range
  27. Using Excel VBA Macro To Capture + Save Screenshot of Specific Area In Same File
  28. Type Mismatch in Loop to scan Outlook Messages [duplicate]
  29. VBA: How to combine two ranges on different sheets into one, to loop through
  30. How to protect Excel workbook using VBA?

Leave a Comment