Find/Search within Userform Textboxes

[liquidmettle]

Hi Everyone,

Does anyone know of macro code to add a search box to a userform? I have a userform with a lot of textboxes that pull their values from my sheet. I'm hoping to add a search feature so that an individual can type a keyword or just part of a word and jump to the relevant textbox.

Even if it has to be a separate userform that is called from a button that would be fine.

Any thoughts, direction, assistance is greatly appreciated.

Thank you!

-LM

[Arkadi]

One option, make a button on the userform and put the following code in it:

Please Login or Register  to view this content.

[liquidmettle]

Hi Arkadi,

Firstly thank you so much for your quick response!

I have attempted to implement and this is my result:

1) The search box comes up just fine, but the search success is sporadic. It finds numbers flawlessly, but combinations of letters (either full or partial words) are very hit or miss. For most it gives the "Text not Found" message box, but others it chooses a weird order. For instance, I search "clin" knowing that in the second textbox, the word "clinic" is present. It instead jumped much further down to a textbox with the word "recycling."

2) Is there a way to allow the user to also hit next in case there are multiple matches for their search to cycle through them? Where perhaps the search box doesn't close until they hit the exit button?

Thanks again!

[Arkadi]

Yes the search order could be fairly random i suppose... At best it would be the order they were created in. Let me give it some thought... Next button is pretty easy, but I may have a more elegant solution.

[liquidmettle]

Hi Arkadi,

Just wanted to check back in to see if you had any thoughts on adding the "next" button. Tried searching myself a bit online once I knew about the "inputbox" from your code, but have not had luck.

Thanks again for the help you've provided so far!