Hi

I have been trying to understand the severals vba codes that exits in the board about the Google maps.
I have found 4 of them and have read and read the code trying to understand each line of code to make one suitable for me...
The problem is that i can´t understand how to parse the html and how to paste what i want in the forms...

I think it's simples what i want to do but i can´t figured out how to do it...

Taking this link here Google Maps Class Module and using it to add some other forms...
Using only the form "StartForm" i want to add some input's on it ( Country, City, Area, street name and coordinates as well) and after fill some or even all of them i want that all the possible options appear listed in a list box (or something) with the area information.

For example if we go to this link http://maps.google.com/maps?q=Portugal,+Fi...mp;t=m&z=16 or if we write on the "StartForm" input address this "Portugal, Figueira da Foz,, Rua da Fé" it will appear several bookmarks because on that State (not sure if it is the correct name in English), that street name exits in several parts of it and it will show them all...
I just want as well that all of them appear in some sort of list box saying as well the other's states...

Using the following example link it will appear on that list box something like this: (or only the States names with out the street name)

R. da Fé, Figueira da Foz
R. da Fé, Ferreira-a-Nova
R. da Fé, Lavos
R. da Fé, Marinha das Ondas,
R. da Fé, Maiorca

At the moment i am still new to vba code but i would like to learn more, sow if you could me point in the right direction i will appreciated.

Note: I can´t figured out as well how can i print something using vba on the input's in the form...

Thanks in advance

Miguel,

Perhaps this previous post can shed some light on your issue - Google Maps


AvgJoe (IMG:style_emoticons/default/hat_tip.gif)

Hi

Nop, but thanks for trying to help...
About the project i found already a way to put my input's working.

I now only need the list box working...
I know already what returns the total bookmarks but i don´t know how can i list them in the list box ...

Any one can help me about it ?

Thanks in Advance

Hi

Using the file that i upload to the server how can i add the bookmarks places to the list box on the "startform" form ?
To test you just need to open the "StartForm" form and click on the button "Take Me There"... You can use any other address example...

Or how can i add anything to the list box ? What vba code i need to use ?

Thanks in advance

This post has been edited by Miguel_A: Mar 31 2012, 10:59 AM

Hi

The last problem i have already resolved...

My problem now is that it's giving to me this error when i try to call a private function ...
"Compile error: Sub or function not defined"

That private sub is being called in a module and the function it self is on the class object part...

How can i defined the sub or what can i do ?

Thanks in advance

Try experimenting and replace the word Private Sub/function to Public Sub/Function.
Anyway its in the class and whatever private sub it will call, it will call in itself.

Hi

Thanks for the tip but it's still not working it's still giving the same error.
i ma using the call command to call the sub ...
If i use the same command in the same place where the sub is created it works, but when using the call command on the module it don´t works...

The funny thing is that yesterday was working but for some reason today it's not...

I will appreciate the help ... thanks in advance

If you make the Sub in the GoogleMap Class public and you already instantiate a Class on your module, you can call it

Call ClassDerivedFromGoogleMap.TheSubYouWantToCall

Hi

Well i have try that and have transfer the private sub to the module place... After some adjustments it does not give any error any more.
Instead any error it happen two things:

For some reason it's making the module always running, even when i close the form. After i close the form and after pressing alt + F11 to go to the module code in the window name keeps saying "running" and it don´t allow me to modified nothing (guess because the module is still being used)...
The other think is that the call sub line does not give any error but don´t add to the list box nothing as well...

If you can check the line 713 in the module GoogleMaps

thanks in advance