http://www.bmsltd.ie/MVP/
This is a free utility that will seach a entire workbook,
find and display all incidences of your search.
as to your second question, i don't think you can do that.

-----Original Message-----

For work, I have a spreadsheet of all my current cases.
Some cases are
listed multiple times for seperate jobs. I need to find
a way to
search for the case number and get the details for each
listing without
knowing before hand how many listings there are for a
particular case.
Does anyone know how to do this?

Also, how exactly do you get the Enter key to create a
click event for
only one button, no matter where in the form you are?
(i.e. hitting
enter in a text bx generates a click on the comand button)

Any help greatly appreciated.

Antro


--
antro
----------------------------------------------------------
--------------
antro's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=15776
View this thread:
http://www.excelforum.com/showthread...hreadid=272933

.