search

Hi All,

have these three column
Cola Colb Colc
aa bb 001
cc vv 002

thousands of rows like this.

Now I want a text box where i enter what am searching for and a search
button next to that.

when i search for aa in the text box
it should display only that row i.e
aa bb 001

How do we do that using VBA programming

Hi Gary,

You can use the 'Auto FIlter' function. Located on the Menu bar select 'DATA
| FIlter | AutoFilter' you then see across the top of you data drop down list
boxes. With each drop down list box you can select 'Custom Filter'. Within
'Custom Filter' you can set up multiple filter parameters, 'search items'.

Look at the help for more info on using AutoFilter, other Excel functions
can be used with autofilter like SubTotal.

HTH
KM

"Gary" wrote:

> Hi All,
>
> have these three column
> Cola Colb Colc
> aa bb 001
> cc vv 002
>
> thousands of rows like this.
>
> Now I want a text box where i enter what am searching for and a search
> button next to that.
>
> when i search for aa in the text box
> it should display only that row i.e
> aa bb 001
>
> How do we do that using VBA programming
>
>
>

Thx Kevin for ur suggestion,

But i need to create this in VBA only... i know abt the Custom filters. But
i need this application to be created in a GUI fashion. Similar to any web
page where we search eg: google

any ideas?
..
"Kevin McCartney" <KevinMcCartney@discussions.microsoft.com> wrote in
message news:E606FDF0-CF64-4C87-90CC-36790A8F6A9B@microsoft.com...
> Hi Gary,
>
> You can use the 'Auto FIlter' function. Located on the Menu bar select
> 'DATA
> | FIlter | AutoFilter' you then see across the top of you data drop down
> list
> boxes. With each drop down list box you can select 'Custom Filter'. Within
> 'Custom Filter' you can set up multiple filter parameters, 'search items'.
>
> Look at the help for more info on using AutoFilter, other Excel functions
> can be used with autofilter like SubTotal.
>
> HTH
> KM
>
> "Gary" wrote:
>
>> Hi All,
>>
>> have these three column
>> Cola Colb Colc
>> aa bb 001
>> cc vv 002
>>
>> thousands of rows like this.
>>
>> Now I want a text box where i enter what am searching for and a search
>> button next to that.
>>
>> when i search for aa in the text box
>> it should display only that row i.e
>> aa bb 001
>>
>> How do we do that using VBA programming
>>
>>
>>