AW: VBA Suche mit String als Rückgabewert
13.05.2019 19:14:32
Sepp
Hallo Christoph,
dann evtl. so.
Sub searchString()
Dim objRegEx As Object, objSubMatch As Object, objMatch As Object
Dim rng As Range, strSearch As String, strReturn As String
Dim varSplit As Variant, lngIndex As Long
strSearch = "data*quality"
If strSearch Like "*[*]*" Then
With Sheets("Tabelle1") 'Tabellenname anpassen!
Set rng = .Columns(1).Find(What:=strSearch, Lookat:=xlPart, LookIn:=xlValues, MatchCase:=False, SearchFormat:=False)
If Not rng Is Nothing Then
Set objRegEx = CreateObject("VBScript.RegExp")
With objRegEx
.Pattern = "(?=" & Trim$(Split(strSearch, "*")(0)) & "\s).*?(\s+" & Trim$(Split(strSearch, "*")(1)) & ")"
.IgnoreCase = True
.Global = True
Set objMatch = .Execute(rng.Text)
If objMatch.Count > 0 Then MsgBox objMatch(0)
End With
End If
End With
Else
MsgBox "Ungültiger Suchstring!"
End If
Set rng = Nothing
End Sub
VBA/HTML-CodeConverter, AddIn für Office 2002-2016 - in VBA geschrieben von Lukas Mosimann. Projektbetreuung:RMH Software & Media
Code erstellt und getestet in Office 16 - mit VBAHTML 12.6.0