Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
placing a point on a image
i have an userform, top 0, width 600
on the userform there is a image, height 348, left 42, top 12, width 258 i have numbers of longitude ranges from 3.88820 to 7.19835 and latitude ranges from 50.76855 to 53.48011 i want to place a point on the image with a longitude and latitude within the named ranges. How can i do that right? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
placing a point on a image
Can you define a second image (Image2) that is small (say 5 pixels wide by 5
pixels tall) and place it on top of the first image (height 348, left 42, top 12, width 258)? Set the background color of Image2 to Black (&H00000000& or use the Pallette tab of the drop-down combe box). Then simply move Image2 around with your code by changing the Left and Top properties. This will give a "square" dot, rather than a round one, but it might work. You will have to figure out how to scale (convert) your longitude and latitude ranges to pixel integers for use with Image1 (i.e. longitude 3.88820 = X pixels up from the bottom of Image1). Remember that the Left property of Image2 (the dot) will be relative to the left edge of the user form, not the left edge of Image1. -- Regards, Bill "Peter Meulenmeesters" wrote in message om... i have an userform, top 0, width 600 on the userform there is a image, height 348, left 42, top 12, width 258 i have numbers of longitude ranges from 3.88820 to 7.19835 and latitude ranges from 50.76855 to 53.48011 i want to place a point on the image with a longitude and latitude within the named ranges. How can i do that right? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically adding image extension ".jpg" to end of image name | Excel Discussion (Misc queries) | |||
Data point on line is not over the point/tick in X axis... | Charts and Charting in Excel | |||
Hyperlink to an image in other worksheet, displaying entire image. | Excel Worksheet Functions | |||
I need more general XY point to point plotting than XY scatter in | Charts and Charting in Excel | |||
Open image from web in window same size as image? | Excel Programming |