| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.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 |
|
#3
Posted to microsoft.public.excel.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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Two search category & two search terms | Excel Discussion (Misc queries) | |||
| Functions (search within search result) reply to this please | Excel Worksheet Functions | |||
| How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
| I cant do a search on this forum. Everytime I search, it comes up with zero results | Excel Programming | |||
| Create a search Field within a worksheet to search command buttons | Excel Programming | |||
Linear Mode
