• 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!!!!!!

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.

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

    • No registered users viewing this page.
  • Posts

    • Quick Machine Recovery was off by default on my install.
    • GitHub customers rejoice as Command Palette deprecation is delayed by Usama Jawad GitHub Command Palette was announced back in 2021, and has been in preview ever since. For those unaware, this capability allows you to launch a search bar UX through the Ctrl + K shortcut, which offers you suggestions based on your current context. So you can quickly clone repositories, edit pull requests (PRs), and more directly through your keyboard, without navigating through cumbersome nested menus. Almost a week ago, GitHub announced that it is deprecating Command Palette due to low usage and popularity. This led to major backlash from the development community who criticized the move, noting that a preview feature that is disabled by default will obviously have low usage. Many customers cited its usefulness, noting that Command Palette has no alternative that is as powerful, and it's unfair for the company to remove a product due to low adoption, especially since it had not been marketed. Now, GitHub has decided to reverse course on its earlier decision (thanks, The Register) and delayed the deprecation of Command Palette indefinitely. It has updated its previous blog post and shared an identical announcement on a dedicated GitHub thread to indicate that after listening to customer feedback and specialized use-cases, it has realized that its own usage metrics do not reflect the current popularity of Command Palette. It understands that the tool is critical in many workflows and that it needs to re-evaluate its overall approach to navigation. During this period of assessment, GitHub Command Palette will continue to be available, much to the joy of GitHub customers, who have responded very positively to the thread. That said, it is important to note that GitHub's wording is a bit vague, and it doesn't concretely say that Command Palette is here to stay. It's possible that the company re-evaluates its usage metrics sometime in the future and reaches the same conclusion that it did last week.
    • I'd say "no thank you" to Recall. Let's turn it off as quicly as possible when installed. And Microsoft -please- don't let a "bug" re-install/re-configure it again.
    • Let's just wait until Patch Tuesday and have most of the bugs on this KB/download be taken care of & ironed out.
    • Just read that before coming here. So sad 😪 Always been one of my all time favorites whether with Sabbath or solo Glad he got the chance to do his 1 last show. Truly going home now.  
  • Recent Achievements

    • Week One Done
      SmileWorks Dental earned a badge
      Week One Done
    • Community Regular
      vZeroG went up a rank
      Community Regular
    • Collaborator
      Snake Doc earned a badge
      Collaborator
    • Week One Done
      Snake Doc earned a badge
      Week One Done
    • One Month Later
      Johnny Mrkvička earned a badge
      One Month Later
  • Popular Contributors

    1. 1
      +primortal
      585
    2. 2
      Michael Scrip
      199
    3. 3
      ATLien_0
      196
    4. 4
      +FloatingFatMan
      134
    5. 5
      Xenon
      122
  • Tell a friend

    Love Neowin? Tell a friend!