• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

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
0
currentdb
Asked:
currentdb
  • 3
  • 2
1 Solution
 
SiddharthRoutCommented:
Is this what you want?

Sid
userform-sample-v7.xlsm
0
 
currentdbAuthor Commented:
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! :)
0
 
currentdbAuthor Commented:
Thanks for your ultra enormous fast help! :)
0
 
SiddharthRoutCommented:
You are welcome :)

Sid
0
 
currentdbAuthor Commented:
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now