create search box

[fady77]

dear all i would appreciate your help by creating a search box with a VBA coding similar to CTRL+F the purpose of tis box it will make our search easier when our data is full with several references
thank you for your help in advance
regards

[Logit]

.
Here is one method :

Please Login or Register  to view this content.

Place a TEXTBOX on your sheet and a COMMAND BUTTON connected to the FINDALL macro.

If you want to highlight all of the items found from the search, create another COMMAND BUTTON connected to the HighlightFindValues macro.

[fady77]

thank you for your help it really appreciated
God Bless