+ Reply to Thread
Results 1 to 4 of 4

Autocomplete in a webedit(text box)

  1. #1
    Registered User
    Join Date
    08-13-2010
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003
    Posts
    4

    Autocomplete in a webedit(text box)

    Hi,

    I am stuck in a middle of a major problem which is hampering my progress.
    My problem is there is a text box in my company's web page that has the autocomplete option enabled. But whenever I tried to input a value in it by the way of excel programming (VBA), it doesn't provide me the autocomplete dropdown.

    The way it works is, once it provides me the autocomplete option, the Autocomplete option has to be selected after which a hidden module appears in the web page. Only after the hidden module is displayed, will I be able to move to the next page.

    I am able to choose the Autocomplete option when I enter the values manually, but the autocomplete option does not appear when done through VBA.

    Could you please tell me how to
    a) input the value into the text box so that the AutoComplete dropdown appears.
    b) Choose the autocomplete option that appears.

    A quick response is much appreciated.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,601

    Re: Autocomplete in a webedit(text box)

    No way to test but...
    Please Login or Register  to view this content.
    Just a thought
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    08-13-2010
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Autocomplete in a webedit(text box)

    Thank you,

    This kind of worked, since I am working on a web page, I used .Focus instead of .SetFocus . Now all I need is to send the following keystrokes to the text box in the web page.

    Space
    Down Arrow
    Enter

    Can you please let me know how to do this.. appreciate your response

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,601

    Re: Autocomplete in a webedit(text box)

    The SENDKEYS Help page shows all the codes and format required.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1