Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA search code
Hi there!
Would like to have a UDF / VBA code for a pragmatic search engine Plan1 - The search criterions Plan2 - My database. Here I have, among some columns, one named "Location" and another one named "Port Code". Plan3 - Blank. Here I'd like to have the search results. In some extents, what I need is: To have on Plan1 two text boxes (on B1 and B2, for instance) where I can type what I want to look for. Either I want to know what is the location code for the port of New York, then I type "New York" on B1 Or I have a port code and want to know what "USNYC" stands for, I type it on B2 So, when I have typed the condition I want (either Location or Port Code), I click OK button, Excel looks for the data on my database on Plan2 and brings all the results on Plan3. I'd like also to have all the results in case I type only a part of a name, i.e., if I type "Charl", I need to have as result: Charles, Charleston, Charlotte, Saint Charles, Cape Charles... Is it possible? Please advise if you need further clarification. Thanks a bunch, Gustavo |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA search code
Gustavo:
I have a search macro that runs through every row looking for a text string. In my macro, the row is hidden if it doesn't find the string. It finds partial strings as well. I use: Set myFind = Rows(i).Find(What:=myTarget, LookAt:=xlPart) If myFind Is Nothing Then Selection.EntireRow.Hidden = True End If where myFind is a Range object and myTarget is the contents of a cell. If you change the return to If Not myFind Is Nothing Then then you'll be able to do something with the result. HTH Ed "Gustavo Strabeli" wrote in message ... Hi there! Would like to have a UDF / VBA code for a pragmatic search engine Plan1 - The search criterions Plan2 - My database. Here I have, among some columns, one named "Location" and another one named "Port Code". Plan3 - Blank. Here I'd like to have the search results. In some extents, what I need is: To have on Plan1 two text boxes (on B1 and B2, for instance) where I can type what I want to look for. Either I want to know what is the location code for the port of New York, then I type "New York" on B1 Or I have a port code and want to know what "USNYC" stands for, I type it on B2 So, when I have typed the condition I want (either Location or Port Code), I click OK button, Excel looks for the data on my database on Plan2 and brings all the results on Plan3. I'd like also to have all the results in case I type only a part of a name, i.e., if I type "Charl", I need to have as result: Charles, Charleston, Charlotte, Saint Charles, Cape Charles... Is it possible? Please advise if you need further clarification. Thanks a bunch, Gustavo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA code for search button | Excel Worksheet Functions | |||
Search Code | Excel Programming | |||
Excel XP VBA code to search all macro code in Excel module for specific search string criteria | Excel Programming | |||
Excel XP VBA code to search all macro code in Excel module for specific search string criteria | Excel Programming | |||
Search code | Excel Programming |