VBA to create a searchbox to search for a key word then an option to find next.

[benosmond]

Good morning all, I am having some problems with some code.


Hello all,

I want to be able to search for keywords in a spread sheet with the option to find next. I understand that I can press CTRL-f but I would like to have a cell with a search box. I have done all I can to get this to work but so far all It will do is find one of many keywords and not find the next in the spreadsheet. Code is below. Can anyone help me with this?

Please Login or Register  to view this content.

[karedog]

Hi,

Look at this code :

Please Login or Register  to view this content.

[stnkynts]

You could also look at creating a userform.

[benosmond]

KareDog, Thanks you so much for the help! This works perfect, Thanks.

Bosmond

[karedog]

KareDog, Thanks you so much for the help! This works perfect, Thanks.

Bosmond

You're welcome Bosmond.