Can Excel Record Mouse Coordinates/Clicks?

I want to be able click on a bar of some kind (be it a jpg or some clip art or something) and generate a number based on where the line is clicked. So, perhaps, clicking to the far left of the line will generate a value of 00, and clicking to the far right will generate a value of 99.

The best method I have come up with is making 100 narrow columns, and having a bit of VBA code return values somewhere else based on what column the cell that was clicked was in. So, in this system, clicking on a cell in row C would generate a value of 02, and clicking on a cell in row Z would generate a value of 25. The problem with this approach, is that I haven't been able to figure out the VBA code to return a value after a click which is linked to the column of a cell.

any better ideas? I'm open to absolutely everything!

Maybe use a Scroll Bar ... Developer Ribbon | Insert | Form Controls | Scroll Bar ... edit the properties to specify a Link cell where it will put the value (and change the increments, etc)


Regards, TMS

THShucks:

Sorry!

So I got it to work the way you said (insofar as linking to a cell, and the return value is concerned). The problem is: if I click inside the scroll bar on either side of the scroll box, the scroll box (and thus the value in the cell the scroll box is linked to) does not jump directly to the position I clicked (this seems to be somewhat controlled by the "page change" function).

is there a way to make the scroll box go to exactly where I click immediately?

I guess changing the page increments to 1, clicking and dragging the scroller, or clicking on the end arrows. Don't use these things as a rule, so it's going to be a case of trial an adjustment.

Regards, TMS