Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27
Default VBA for "Find" function

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text "comparison" operator for "contains" used in an "IF" Function Pawaso Excel Worksheet Functions 4 April 4th 23 11:35 AM
"Find" a wildcard as a place marker and "replace" with original va Eric Excel Discussion (Misc queries) 1 January 27th 09 06:00 PM
HELP on "left","right","find","len","substitute" functions serene83 Excel Discussion (Misc queries) 5 June 27th 06 02:23 AM
Please add a "sheet" function like "row" and "column" functions Spreadsheet Monkey Excel Programming 2 November 8th 05 04:08 PM


All times are GMT +1. The time now is 10:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"