"Find" using VBA

[Bob Wickham]

Hello,
I'm trying to use VBA to search to through all sheets of a workbook and find
a specially formatted instance of the value that is in Sheet 1, Cell A4.
For instance, if the value of Sheet 1, Cell A4 is "1001", I need to find
where in the Workbook that value is formatted Bold Italic.
The catch is, the value of A4 changes.
I have had some success using the Macro Recorder if the value of Cell A4 is
fixed but any altering of that code returns an error.
Any help appreciated.

Bob

 

[Bob Wickham]

Thanks Dave, works terrific.
Excels "Find" does the job as well but I was having a hard time getting it
to work by clicking a Command Button to run some code. Especially as the
Find criteria changed.