confining a search to 2 columns

[Picto]

Hi

I have the following code to search a worksheet for a value typed into a textbox. the key words on the sheet are in columns B and C. How do i confine the search to just those columns.

Please Login or Register  to view this content.

if i add

Please Login or Register  to view this content.

into this procedure it only finds the first instance of the word (because it is resetting the search each time you click the button)

[royUK]

Try this

Please Login or Register  to view this content.

[Picto]

Cheers Roy...it works a treat

Thanks
Shaun