Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 117
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically adding image extension ".jpg" to end of image name Alain Excel Discussion (Misc queries) 3 June 19th 08 03:21 PM
Data point on line is not over the point/tick in X axis... TomCat Charts and Charting in Excel 2 September 6th 07 01:36 PM
Hyperlink to an image in other worksheet, displaying entire image. twilliams Excel Worksheet Functions 0 February 7th 06 10:02 PM
I need more general XY point to point plotting than XY scatter in spazminator Charts and Charting in Excel 12 December 19th 05 05:00 PM
Open image from web in window same size as image? Milos Setek Excel Programming 0 February 5th 04 03:33 AM


All times are GMT +1. The time now is 10:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"