Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
grid references on a map
Hi there
Is it possible to plot pixels in an object/image that I have placed on my worksheet. Let's say I have an image on my screen which is an outline map of the UK, be-it a bitmap , GIF etc, from a list of X and Y values (ie GIS grid references) can I plot a pixel within the object/image on my worksheet. I can calculate where the X and Y should be from my list of values. All I want to do is edit the object/image within Excel. To better explain this, we all have I presume MS Paint , load in an image and draw lots of dots over it. Can I use Excel to do the same or similar thing. In a nutshell it's plotting HotSpots . TIA., kevin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
grid references on a map
from the toolbar "control toolbox"
insert an image on the sheet. click the properties button on the toolbar and goto property: PictureSizeMode = select clip or stretch.. goto property: Picture = click the ellipse and browse to insert your map's jpg. now exit designmode by clicking (blue)ruler button on the toolbar. open VBE, open the sheet module of the worksheet select the control in the topleft dropdown. (e.g. Image1) select the mousedown event in the topright dropdown see ?... you've got an x and a y to work with :) keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "kevin Gaisford" wrote: Hi there Is it possible to plot pixels in an object/image that I have placed on my worksheet. Let's say I have an image on my screen which is an outline map of the UK, be-it a bitmap , GIF etc, from a list of X and Y values (ie GIS grid references) can I plot a pixel within the object/image on my worksheet. I can calculate where the X and Y should be from my list of values. All I want to do is edit the object/image within Excel. To better explain this, we all have I presume MS Paint , load in an image and draw lots of dots over it. Can I use Excel to do the same or similar thing. In a nutshell it's plotting HotSpots . TIA., kevin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - "Snap To Grid" doesn't work on same grid line | Excel Discussion (Misc queries) | |||
Grid lines in Excel not showing.Have tools,options,view/grid cked | Excel Discussion (Misc queries) | |||
Rationalising grid references | Excel Discussion (Misc queries) | |||
I need to convert grid.doc to an Excel Grid. | Charts and Charting in Excel | |||
grid references to pushpins on a map | Excel Programming |