Autocomplete in a webedit(text box)

Paddy_

New Member
Joined
Jan 29, 2010
Messages
13
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.
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Paddy

I don't know if this will be possible, isn't AutoComplete a browser setting rather than one specific to a particular page/input element?

Do you need to use it to enter what you want?
 
Upvote 0
Yes Noorie,

I realize that Autocomplete is a browser setting but I need that Autocomplete to move to the next page.

To be more specific, what I enter is the name of a person in that text box. On enter or while entering, I am provided with the Autocomplete option with the full name of that person. On choosing that Autocomplete option, I am then displayed the correct mailing address of that person so as to make sure that the intended person is selected. After which I am allowed to click on the continue button which will then displayed me the next page.

Could you please let me know if this can be done?
 
Upvote 0
It is similar to the Autocomplete option that Google displays. So if I can find a way to make it work on Google, then I think it will help me in my project.
 
Upvote 0
I can't really think of a way to do this unless there is some sort of autocomplete list stored somewhere that you can access.

Why do you say you need this to move to the next page?

Wouldn't entering the correct data, using AutoComplete or not, work?

How are you currently working with this?

Are you using code?
 
Upvote 0
I did try it without the AutoComplete option but unfortunately it did not provide me the hidden module (email address) of that person. Because of this I could not move on to the next page.
 
Upvote 0
Sorry. I did not notice the other part of you question, yes I am using VBA to do it. Well, I am trying to atleast.
 
Upvote 0
Paddy

I had a quick look and I can't seem to find anything.

One thing about AutoComplete is that it doesn't always have the correct information.

I tried logging on to a webmail account I rarely used and there were some bogus usernames listed.

I'm sure I've had problems in the past with passwords too and ended up having to type the correct password and then tell the browser to save it.

I'll look into it further.

Any chance you can post the code you have so far?

Are there any other options available? eg constructing a list of names/addresses or whatever.
 
Upvote 0
Thanks Noorie,

I couldn't find any other options/workarounds for it. Sorry about the code Noorie, I would not be able to post the code for it since its somewhat confidential.

But it works on the same principle as Google's AutoComplete option for its search text box.

Thanks for your help. Looking forward to your answers.
 
Upvote 0
Well as far as I can find the answer is no you can't do it.

Some INPUT elements have an autocomplete option but all it tells you is if it's turned on.

The article I was reading then went on to mention VCARDs (?), encrypted lists and other stuff.

Somebody had asked a question regarding if it was possible to show the autocomplete dropdown and apparently you can't.

That was something to do with a event(s) not being triggered.

As for your code, it wouldn't be the confidential part that anybody would be interested in.

PS I think Google'a AutoComplete might be something different - there are some input boxes with autocomplete, but they all seem to be set to off.
 
Upvote 0

Forum statistics

Threads
1,223,893
Messages
6,175,249
Members
452,623
Latest member
Techenthusiast

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top