Results 1 to 5 of 5

Can Excel Record Mouse Coordinates/Clicks?

Threaded View

  1. #1
    Registered User
    Join Date
    08-31-2012
    Location
    Amherst, MA
    MS-Off Ver
    Excel 2010
    Posts
    22

    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!
    Last edited by Rufius; 09-01-2012 at 07:24 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1