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.
Bookmarks