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

search
 

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

search
 

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" wrote in
message ...
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