Hello,
I was just wondering if it's possibe to highlight a cell/word when the find function (ctrl f) is used, and if it is how would one who doesn't know much go about doing it?
Many thanks.
Hello,
I was just wondering if it's possibe to highlight a cell/word when the find function (ctrl f) is used, and if it is how would one who doesn't know much go about doing it?
Many thanks.
Hi jeremy,
You need to be little more specific. Are you saying about worksheet function "Find" or are you referring to ctrl+f because when you do ctrl+f, the found cell will always be selected / highlighted.
Regards,
DILIPandey
<click on below 'star' if this helps >
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Hi jeremy14,
Ask your boss to use below code:-
Regards,Sub find() i = InputBox("Enter value to Ctrl+F", "Ctrl+F") n = Application.WorksheetFunction.CountA(Range("a1:iv65536")) Range("a1:iv65536").Select Selection.Interior.ColorIndex = xlNone Cells(1, 1).Select Cells.find(What:=i, After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _ , SearchFormat:=False).Activate Call Format For a = 1 To n - 1 Cells.FindNext(After:=ActiveCell).Activate Call Format Next Range("A1").Select End Sub Sub Format() With Selection.Interior .ColorIndex = 6 .Pattern = xlSolid End With End Sub
DILIPandey
<click on below 'star' if this helps>
Last edited by dilipandey; 12-16-2011 at 06:51 AM. Reason: coding pattern corrected
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks