asked on

Open map location in a second userform

Dear Experts,

I'm trying to make this code work:

Set appBrowser = Me.UserForm4.WebBrowser1

Open in new window

This is a follow-up question from here

As the initial userform grew with more and more fields, it became relevant that the map location would take too much space. A better alternative was to call the map from a button who would open a second userform.

I thought I will only change a part of the code and show userform4 (which contains the map).

But maybe I'm wrong somewhere.

Any help woud be appreciated.

thanks
currentdb

ASKER CERTIFIED SOLUTION

SiddharthRout

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

currentdb

ASKER

Hi Sid,

Yes exactly! :)

While I was waiting, I also figured this:

Set browser = CreateObject("InternetExplorer.Application")
   browser.Visible = True
   browser.Navigate strGoogleMapURL

Open in new window

And it will open Internet Explorer rather than another userform. Looking now at the code you wrote for userform 4, I can see that it was much more easier than I thought. I just did not think to copy it on the userform4.

Thanks again for your ultra fast help! :)

currentdb

ASKER

Thanks for your ultra enormous fast help! :)

SiddharthRout

You are welcome :)

Sid

currentdb

ASKER

H Sid,
If you are around, I opened a new question here: https://www.experts-exchange.com/questions/26903079/Filter-data-from-an-userform.html

Thanks!