I don't understand the question.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"rjw24" wrote in message
...
Thanks for coming back to me

Unfortunately, I cant download the first responses template because I'm at
work which prohibits downloading from unconfirmed sources.

I ran your code and it worked. However, I wonder if theres a way of having
the find dialogue box results which shows a list of all those matches and
is
clickable using this method.





"Don Guillett" wrote:

Try this to look in each sheet

Sub findinworksheets()
what = InputBox("Enter search word")
'or
'what=Range("a1")

For Each ws In Worksheets
Set myfind = ws.UsedRange.Find(what, LookIn:=xlValues, _
LookAt:=xlWhole, MatchCase:=False)
If Not myfind Is Nothing Then Application.Goto myfind, True
Next ws
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"rjw24" wrote in message
...
Hi,

I have a search term cell where the value the user wants to search can
be
typed. I want to then click a search button which will search the
entire
workbook for this term. I am happy to use the dialogue but am unsure of
how
to go about it. I have tried recording a macro but this didnt work.

Thanks