Create a 'click map' on an image

Hi all,

I have been making some sort of database in excel that uses VBA queries to enter new datapoints. Without going too much into detail here, each of those datapoints gets defined by a couple of 'general' characteristics and also a couple of more individual characteristics. Afterwards, it uses VBA to help the user isolate a selection of datapoints based on a parameter of his choise. This in turn fills out an automated report sheet that gives me the graphs I need.

So far, all of that works more or less the way I want it too. The problem is that I want to add one final characteristic to each datapoint: a location on an image.

Basically I am looking for a way to use a userform that displays an image. The purpose here is to let the user click on a location on the image and that location (X, Y coordinates of the mouse over the image) should be stored in the database for each click.
This is the first step and if I could get this working, it would already be such a big help.
The final step is that I should be able to display the locations of a selection of datapoints on the image as seperate single red dots for example.

I have been searching the internet for information how to do this. The closest I got is this site: http://www.josluyendijk.nl/Entertain...ConvHtml5.html which makes me believe it is possible. But my VBA/userform knowledge is too basic for me to get this example working, let alone to adapt it to what I need. I was hoping to recieve some help from this community.

After some further research, I'm trying to put the pieces of the puzzle together. Here is what I have so far:

I created a userform (userform1) with a big button. Instead of text I load an image on that button, the image I want to click on.

worksheet code:

Please Login or Register  to view this content.

Userform1 code:

Please Login or Register  to view this content.

Like it says in the code: I need to find a way to retrieve the x.pos and y.pos values in that first sub. I can write the values to cells and read them ion the main sub again to load x and y, but there must be an easier way to do this.