Macro Help

[leolin]

Hi,

I would like to create a macro to find certain
information in a large file.

Ie I would like to click a marco button that would then
use a pop up screen for you to type in your data you want
to search and then click ok and the macro finds the
information and returns it to you. Something like a
filter.

I know how to run macros but not sure how the get the pop
up screen, any suggestions would be appreciated?

 

[Dave Peterson]

xl2002 added an option to find in workbook.

in xl2k, you could group your worksheets and do edit|find.

But in all versions, you can use Jan Karel Pieterse's FlexFind:
http://www.bmsltd.ie/MVP/