Solved

Open map location in a second userform

Posted on 2011-03-02
5
274 Views
Last Modified: 2012-05-11
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
Comment
Question by:currentdb
  • 3
  • 2
5 Comments
 
LVL 30

Accepted Solution

by:
SiddharthRout earned 500 total points
ID: 35020785
Is this what you want?

Sid
userform-sample-v7.xlsm
0
 
LVL 1

Author Comment

by:currentdb
ID: 35020917
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
 
LVL 1

Author Closing Comment

by:currentdb
ID: 35020922
Thanks for your ultra enormous fast help! :)
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35020925
You are welcome :)

Sid
0
 
LVL 1

Author Comment

by:currentdb
ID: 35189249
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now