Pass textbox value to google search to look up post code

[nigelog]

Hi All
Has anyone an example or pointer to a method of passing an Eirecode value (postcode) from a userform textbox click event that will open explorer or chrome and search for the parameter passed from textbox. I am wondering if this is possible as an aid to route planning

any ideas appreciated

[vba_php]

use the followhyperlink method in code attached to the click event. more than likely that will do what you need. be aware though, that the method I've just mentioned will open the browser that you have set as default. you don't have a choice. as far as passing the value from the box to a webpage HTML element, you have to use code to do it because Excel's interface commands and menus can't do stuff like that. it has no connection to browser programs, I don't believe, other than powerquery, which can query webpage HTML tables and stuff.

if you use the IE object in VBA code, you can do this by using the DOM (document object model) and writing javascript commands. for instance:

Please Login or Register  to view this content.

[nigelog]

Thanks for answer I'Ll dig further

[CK76]

I don't recommend using event trigger on textbox. If you must, may be use Exit event.

But in general, it's safer to use CommandButton or other means to trigger action.

Ex:

Please Login or Register  to view this content.

In Standard module.

Please Login or Register  to view this content.

As previous poster alluded to. Reading contents of browser can be bit more tricky. And since IE is at end of life (support ends in Mar 2021)...

You may be better off using Selenium Wrapper for VBA. Though I have no experience with that.

[vba_php]

Please Login or Register  to view this content.

I have always found the .readystate and .busy are both extremely unreliable. I tested both of them along time ago, and have never liked either of them.

[CK76]

It's usually a must when you interact with IE or browser.

Alternate approach, if you are certain of the site/page structure and know the element that will hold value that you are after (which could be filled via javascript, Ajax, etc).

Then you can check until element is present, or check that it matches expected pattern.

Piloting browser is always going to be unreliable when compared to using web request directly (XMLHTTP, WINHTTP etc). However, it's necessary for scraping site that generates content via script/code.

For geocode, map, route etc. I prefer to leverage API. But depending on use case, API may not be suitable. There's always more than one way to solve problems. It's just matter of what approach best suites your particular need.

[vba_php]

There's always more than one way to solve problems. It's just matter of what approach best suites your particular need.

no argument.

[nigelog]

@CK76
thankyou, in this instance seems to work ok from a command button search.