and set focuses on the found word.
This is a snippet of code in finding the code
Code: Select all
Found = ActiveWorkbook.VBProject.VBComponents("Module1").CodeModule.Find(Target:=FindWhat, StartLine:=SL, StartColumn:=SC, _
EndLine:=EL, EndColumn:=EC, _
wholeword:=True, MatchCase:=False, patternsearch:=False)
Dim FindWhat As String
Dim SL As Long ' start line
Dim EL As Long ' end line
Dim SC As Long ' start column
Dim EC As Long ' end column
Dim Found As Boolean
I know the code works well but the problem is...
Once I run the code, it doesn't show where the word was found.
Hence, I am hoping to use SetFocus function to focus onto the word.
If there's any other way than SetFocus function, please tell me :D
and don't be afraid to make suggestions, ideas, or just comments!!
Thanks in Advance