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!
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!
