trying to make a simple search.....
 

I have a large worksheet with many columns.

I've already got some code running to highlight the row that the cursor is
currently on (making it easier for the user to see the row).

I'm trying to figure out a better way to conduct a search (for any string in
the worksheet) that doesn't use the built in CTRF-F. I find CTRL-F
cumbersome as you have to close the FIND pop-up to swtch to another workbook,
or use the scroll bars, etc. And although it finds what I am looking for, I
lose the row highlight feature until I close the FIND pop-up window, and
click on the worksheet again....

I'm open to suggestions but would prefer a userform that could be anchored
somewhere on the document (always visible).

Thanks in advance!

trying to make a simple search.....
 

What is it you are trying to find? is it in the same worksheet or the
same workbook?


--
The Code Cage Team

Regards,
The Code Cage Team
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=35170

trying to make a simple search.....
 

I'm trying to find "anything" on the sheet, in other words, I'd like a search
tool, that could find Surname, Name, phone number, fax number etc. or any
portion there of. For example, if I needed to find the surname Smith, I
could type in Smith or maybe Smi, or Smit and the search would look for the
first occurence of any of these. CTRL-F does this, but prevents other macros
from running until you close it's pop-up.

Essentially, I need a search that stays open on the page, but doesn't stop
someone from scrolling around either. The CTRL-F has to be closed before you
can move around.

I did manage to find a great example of a SOUNDEX worksheet, but can't seem
to make it work on my page for some reason :(

Thanks

jestercat

"The Code Cage Team" wrote:


What is it you are trying to find? is it in the same worksheet or the
same workbook?


--
The Code Cage Team

Regards,
The Code Cage Team
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=35170