BrianB,
That worked fine. There is a few other things I need as well:

1. When searching for the value in textbox1, there might be more cell
with the same result than just one. I need all cells to be selected.

2. As mentioned, there are three textboxes in the form, and only th
one with a value in it, should be used for the search. How is tha
done?

Thnks

--
Message posted from http://www.ExcelForum.com