+ Reply to Thread
Results 1 to 6 of 6

I want to select a point on a plot, and then write it's coordinate values on a cell on...

  1. #1
    Registered User
    Join Date
    06-13-2012
    Location
    Spain
    MS-Off Ver
    Excel 2010
    Posts
    4

    I want to select a point on a plot, and then write it's coordinate values on a cell on...

    Hello friends,

    I am not new to programming but I am very new in coding on excel.

    I have a plot with full of points. I just want to select a point on a plot, and then write it's coordinate values on a cell on the worksheet. How can I do this?

    I have knowledge about class structure from C++ but since I have no idea about how VBA works, I can't solve this problem easily. Could you please tell me how I can solve this issue?

    Thanks a lot!

  2. #2
    Registered User
    Join Date
    06-13-2012
    Location
    Spain
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: I want to select a point on a plot, and then write it's coordinate values on a cell on

    Nobody knows the answer?

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,437

    Re: I want to select a point on a plot, and then write it's coordinate values on a cell on

    See previous post wth examples of using chart events to capture clicking.
    http://www.excelforum.com/excel-prog...-function.html
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    06-13-2012
    Location
    Spain
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: I want to select a point on a plot, and then write it's coordinate values on a cell on

    Sorry but I still don't get it.

    Perhaps I have to study VBA. Do you have any recommendations? Like video tutorials, etc?

    Thank you very much

  5. #5
    Registered User
    Join Date
    06-13-2012
    Location
    Spain
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: I want to select a point on a plot, and then write it's coordinate values on a cell on

    Hello friends,

    I am really lost. Dear Andy Pope, I couldn't understand the example that you showed me.

    Could someone help me?

    Thanks

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,437

    Re: I want to select a point on a plot, and then write it's coordinate values on a cell on

    Why not post an example of your workbook, if you can not understand the other examples.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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