I would like to search a Excel List of names(voters Registration list) by typing a name to see if that person is registered. Can anyone advice me how to do it or provide me with a sample program
Jump to Post
Try the following, in your macro -
Function TextExtract(ByVal strSearchFor, ByVal Target As Variant) As String Dim OneCell As Range TextExtract = "" If TypeName(Target) = "Range" Then For Each OneCell In Target If InStr(1, OneCell.Text, strSearchFor, vbTextCompare) > 0 Then TextExtract = strSearchFor Exit For End …
All 2 RepliesReply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.