• 0

Vba - textbook search to select listbox entry


Question

Ok guys as the title states I am wanting to be able to type whatever in a textbook and then in button.click auto select the first match in a listbox.

So user enters text, clicks button, if the text is a match to an entry in listbox it selects it.

The listbox is loaded from a textfile as extra info but I don't think that's relevant.

Even if it's a pointer in the thought direction it will be useful, thanks guys!!!!!!

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Ok, I think I got it, using InStr to search for a partially string within the full string of a selected index of a listbox.

Put it on a loop and voila, keeps going one by one until it finds the partial string typed into a textbox.

Will post up working code when I get the chance incase it helps anyone else.

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.