ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   placing a point on a image (https://www.excelbanter.com/excel-programming/294365-placing-point-image.html)

Peter Meulenmeesters

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?

Bill Renaud[_2_]

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?





All times are GMT +1. The time now is 05:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com