Search input box

[Guest]

Is there a way to construct a 'search' input box that acceps a string (eg
BoatName='OceanDance') and a column paramter eg (Column=C) and then returns
the rows relating to that user criteria....

Very much appreciated
Jason

 

[Tom Ogilvy]

Try using the Autofilter under the Data=>Filter menu. If you need code,
turn on the macro recorder while you do it manually.

 

[Guest]

Will these macros work across all machines.....?

Isn't there a problem with mouse vs keystroke macros...

Many thanks
Jason

 

[Tom Ogilvy]

If you record the macro on the earliest version of Excel that will need to
use it, you should have no problems.

As recorded, the macro will need to be enhanced to allow dynamic selection
of a value - using the inputbox function as an example and substituting the
result in the Autofilter command.

Or you might find that instructing your users how to use Autofilter may
eliminate the need for macros.