hi,
i have one sheet with a map with coords X and Y , and other sheet with names with coords X and Y, and i wanted to create a button, that when activated, the names would appear in the map, by the coords X and Y.
i dont understand very much VBA, so i wouldlike to have Help.
thks
Last edited by Nuno Neves; 07-09-2011 at 07:33 AM.
Please Login or Register to view this content.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
Thankyou very much DaveGugg
it works perfectly
can I, ask only one more thing before i close the thread
its possible, to appear in the map, instead the name on the cell a colour ? and the name on a comment ?
Excell have the possibility to write a comment on a cell, it would be perfect if in the cell appears a colour and attached to the cell the comment with the name of the person.
thks in advance
The following code will color the map red. To choose a different color, change the 3 to a different number. You can see what numbers refer to what colors here.
You can't add more comments to a cell while there are already comments. For example, Carolina, Linda, and Ana all have the same coordinates, so adding comments by code will fail when you try this. Let me know how you want to proceed.Please Login or Register to view this content.
thks , yes, my intention was, in one comment to the same cell , to add all the names that have the same coords.
so one comment will have all the names with the same coords.
Give this a shot:
Please Login or Register to view this content.
it gives an error : Run-time erro "1004"
no cells were found
could you also make a command to clean the data on the map , thks, sorry for the trouble.
I hate this fix:
This will clear the map:Please Login or Register to view this content.
Please Login or Register to view this content.
Thks Dave, awesome work
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks