• AutoComplete in VBA Forms? (Office 2000 SR1/VBA)

    Home » Forums » AskWoody support » Productivity software by function » Visual Basic for Applications » AutoComplete in VBA Forms? (Office 2000 SR1/VBA)

    Author
    Topic
    WSHubert_NY
    AskWoody Lounger
    November 20, 2002 at 1:38 pm #379712

    Does anyone have any information on using IE’s autocomplete feature in a custom VBA form inside Word? Essentially, I’m trying to create a text box in a Userform that will keep track of previously entered information and then resolve any matching entries.

    For example, let’s say a user enters a list of names… [Jane Doe, Robert Smith, Bob Jones]
    The next time the user goes to the text box and enters “Jones”, I’d like the autocomplete feature to offer an option of using “Bob Jones”.

    I have a method of doing this by storing the last x number of unique entries in the registry or in an INI file and checking the field on exit using the “LIKE” operator with wildcards, but IE’s autocomplete feature seems to be prospectively more elegant. Any tips?

    Thanks!

    Reply | Quote
    Viewing 1 reply thread
    Author
    Replies
    • WSSammyB
      AskWoody Lounger
      November 20, 2002 at 2:18 pm #633122

      Hubert, I have no experience with IE, so I cannot comment about trying to use it. However, if your application is Excel, then you can easily use Excel’s AutoComplete method for a range object in the change event. It’s a little tricky because your changing the textbox’s text will generate another change event.

      Also, just found this code, Adding AutoComplete to a VB Text Box. It’s for VB not VBA, but it’s usually pretty simple to migrate. Let us know if it works! Sounds useful. –Sam
      HTH –Sam

      Reply | Quote
    • WSSammyB
      AskWoody Lounger
      November 20, 2002 at 2:39 pm #633142

      Just noticed a problem with the VB code in the link that I posted. It needs a window handle, hWnd. There is no such property in VBA, so you have to resort to more API. Assuming, that you are using a Userform, put a command button on the form and add the following code to see the window handle.

      Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" _
                (ByVal lpClassName As String, _
                 ByVal lpWindowName As String) As Long

Private Sub CommandButton1_Click()
dim hWnd as Long
    hWnd = FindWindow(vbNullString, Me.Caption)
    MsgBox hWnd
End Sub
      Reply | Quote
      • WSHubert_NY
        AskWoody Lounger
        November 20, 2002 at 3:33 pm #633177

        Thanks Sammy. I’ll try this out this afternoon and let you know how it goes.

        Reply | Quote
      • WSHubert_NY
        AskWoody Lounger
        November 22, 2002 at 3:24 pm #633779

        Sammy–I tried out the code and the code seems to fire without error, but I don’t get any autocomplete suggestions. I must be missing something.

        I assumed that hWnd should be set to me.Text1 and not me.caption, but I tried it both ways without success. I also wasn’t sure if my call to the SHAutocomplete function in VBNet’s code for the Command1 button should pass the constant SHACF_DEFAULT or if SHACF_AUTOSUGGEST_FORCE_ON or SHACF_AUTOAPPEND_FORCE_ON were more relevant. I also tried all permutations here but to no luck.

        I started wondering–Do I need to store my entries somewhere in the registry and then have the textbox point to the stored entries in order for this to work? (sort of like how IE’s typed URLs are written to the reg).

        Any clarification or suggestions would be greatly appreciated!

        Thanks,
        Hubert

        [For clarification, my textbox is in a custom userform working in VBA for Word2000.]

        Reply | Quote
        • WSjscher2000
          AskWoody Lounger
          November 23, 2002 at 1:03 am #633942

          > I assumed that hWnd should be set to me.Text1 and not me.caption, but I tried it both ways without success.

          Do you get a value in the MsgBox for hWnd? It should be an integer (other than 0) that identifies the UserForm as a window in Windows’ big catalog of windows. It should work if you use the text that appears on the title bar of your UserForm. “Should,” but I haven’t tested it, and it’s possible that it’s not available in VBA.

          Reply | Quote
          • WSHubert_NY
            AskWoody Lounger
            November 24, 2002 at 4:08 pm #634127

            Thanks Jefferson. Unfortunately, I do get a value for hWnd–and if I switch hWnd between me.Text1 and me.Caption, I get two different values–so I’m still guessing that the problem must be in the codes’ failure to explicitly read/write the values somewhere. Urrgh.

            Reply | Quote
            • WScharlotte
              AskWoody Lounger
              November 24, 2002 at 5:39 pm #634135

              If Text1 is a control, you’re probably getting the hWnd for that control rather than for the application or form window.

              Reply | Quote
    Viewing 1 reply thread
    Reply To: AutoComplete in VBA Forms? (Office 2000 SR1/VBA)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    March 2025
    S M T W T F S
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    3031  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.