highlighting multiple entires across sheets

[mridz]

I have a small problem.I am trying to find a given value which might have multiple entries across sheets.
what i need to do is this:

1.Find the value and highlight the row containing this value across all worksheets.
2.Can I have a dialog box similar to FIND so that I can enter a value and it highlights all matches across worksheets.
3.Is there a way in VBA to map this to a keystroke like CTrl+F for find.

Any help would be highly appreciated

Thanks,
Mrudula

 

[mridz]

hi...

i am actually done woth the finding and highlighting part,thank to some amazing entries here.I just need to know how I can map this macro to a keystoke...say Shift+a or something like that

 

[fairwinds]

Hi,

In Excel (not vb editor):

Tools - Macro - Macros - Select the macro - Options ....