grid references on a map

K

kevin Gaisford

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
 
K

keepITcool

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 >
 
Top