Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to display map that user selects region
I want to have an Excel column that would specify a location region. And to
make it easier I would like Excel to bring up a map when the user clicks on the cell, and then allow the user to click a region on the map which would then close the map and display the name in the cell. How would I go about doing something like that? I presume I need a macro. I have a computer science background, but not in macros. Thanks!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to display map that user selects region
Jack,
You could have an Excel event capture when a client clicks on a certain cell. You could then launch a browser, or embed one in your current spreadsheet. Using the DOM (document object model), you could recognize when certain events occur in the browser and pass that information back to Excel. -- http://HelpExcel.com 1-888-INGENIO 1-888-464-3646 x0197758 "Jack Gur" wrote: I want to have an Excel column that would specify a location region. And to make it easier I would like Excel to bring up a map when the user clicks on the cell, and then allow the user to click a region on the map which would then close the map and display the name in the cell. How would I go about doing something like that? I presume I need a macro. I have a computer science background, but not in macros. Thanks!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to display map that user selects region
make a second sheet. Draw the elements of your map using the Freeform shape
found in the autoshapes of the drawing toolbar. Each region should be a separate shape. Assign a macro to each shape. The macro will then fire when the shape is clicked . The macro should perform the appropriate action. You can then display this sheet when necessary. -- Regards, Tom Ogilvy "Jack Gur" wrote in message ... I want to have an Excel column that would specify a location region. And to make it easier I would like Excel to bring up a map when the user clicks on the cell, and then allow the user to click a region on the map which would then close the map and display the name in the cell. How would I go about doing something like that? I presume I need a macro. I have a computer science background, but not in macros. Thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort by name when user selects name on another worksheet | Excel Discussion (Misc queries) | |||
Need an input box when user selects a value in a drop down box | Excel Worksheet Functions | |||
Is this possible...Filter list after user selects location | Excel Programming | |||
Make Sure User Selects 3 Cells | Excel Programming | |||
User selects a range | Excel Programming |