LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Cells.Find method and Boolean operators


Hi,
I have a small database on a worksheet (4 Columns x 6627 rows). I would
like to put a search feature on this worksheet with a Userform as the
interface. The search would only have to look at the 4th column.
I thought the code would center around the Cells.Find method, but I
can't seem to generate any code (by macro recorder), which might give
me a clue as to how I might incorporate boolean operators. I don't even
know if this is possible.
In the Object Browser I found a "FindB" member that lists it's
arguments as strings, but I can't find any more information in the help
files on FindB. Any help/guidance would be greatly appreciated.
Thanks in advance for any help.


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=497442

 
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
Boolean Operators In search and Replace Colin Hayes Excel Discussion (Misc queries) 4 January 29th 08 02:25 AM
Are there Boolean operators in MS Excel? Aashu Excel Discussion (Misc queries) 5 August 4th 06 02:41 PM
Boolean Find Bill Excel Discussion (Misc queries) 2 May 31st 05 10:52 PM
How select/define cells with FIND method (maybe together with SpecialCells) Marie J-son[_5_] Excel Programming 2 December 14th 04 03:49 PM
boolean find criteria in Excel davista00 Excel Discussion (Misc queries) 1 December 1st 04 03:45 PM


All times are GMT +1. The time now is 02:44 PM.

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

About Us

"It's about Microsoft Excel"