Creating a search bar using VBA

[Steve_123]

Hi there

I'd like to create a search bar where someone types text into a field in Sheet1 (in the sample B1), then clicks a macro button to search for that word in Sheet2.

The result should be that the cell containing that word is where you end up.

The search word shouldn't be an exact match for the result, the cell just needs to contain it.

The search bar should also be present on Sheet2, with an additional button for Find Next, so that the user can move to the next result if the first one is not what they're looking for.

I've managed to create a search function with a pop up box using the below but this isnt as effective.

Any help much appreciated as ever!

Thanks

Please Login or Register  to view this content.

[jewelsharma]

May I suggest you create a UserForm instead of using the InputBox. A UserForm will stay 'alive/present' between sheets and you can easily provide a 'find next' button on it.

[Steve_123]

Taht's great, thnaks!