|You are aware that Excel's Find dialog includes a "Find all" option, aren't you?|
When you use Find All, a link is provided to each found item so that the user can "quickly access" each item with the dialog box open.
It won't highlight them all, but it will take the user directly to each one as each link is clicked.
re: "Then once the "search box" has been closed, the highlights will disappear for future searches."
Highlighting the found items via an InputBox created within VBA will not allow the user to access the found items with the InputBox open.
VBA can be certainly be used to present the InputBox and highlight (or un-highlight) all of the found items, but once the user clicks OK to find/highlight the items, the Input Box will close.
For example, this code will present an InputBox to the user, close after the user clicks OK and then highlight all of the found items in Column A.
Once it is run again, it will un-highlight the previous found items and get ready to highlight the next set of items.
lastRw = Range("A" & Rows.Count).End(xlUp).Row
Range("A1:A" & lastRw).Interior.ColorIndex = xlNone
get_Term = Application.InputBox("Enter Search Term")
With Worksheets(1).Range("A1:A" & lastRw)
Set c = .Find(get_Term, LookIn:=xlValues)
If Not c Is Nothing Then
firstAddress = c.Address
c.Interior.ColorIndex = 6
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address <> firstAddress
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.