Userform Grid overlay

[phagan]

I would like to creat an invisible grid overlay or underlay with a picture so that when some one clicks on the picture in a certain area it would save the grid section to the spreadsheet.

example:
Picture with a 9 section grid overlay;
If someone clicks the top right portion of the picture the userform saves a 3 to the spreadsheet.

if someone clicks on the center of the picture it saves a 5 to the cell.

This would be so that we can track which area of parts have the most defects, Is it possible to do this?

 

[mikerickson]

You could either have 9 Pictures and 9 Image_Click events.
Or one Picture and test the x and y arguments of the MouseDown event to decide what value to send to the worksheet.

 

[phagan]

I hadn't thought of the x y cordinates aspect but for what I want to do that other option would probably work best. As I am going to want to be able to pull up the info on the part later and show with a red overlay which area has the most defects for the month or year.