Using mouse/userform to move a point on a scatter chart

[hamang]

I have an embedded scatter chart of a grid of X,Y coordinates and am wondering if I can use the mouse to click on any point and then move it a small distance to a new X,Y position (i.e. updating the columns of X,Y values in real time). At the moment I have some code I downloaded (pasted below), and modified with help from this forum, that I can use to write out the X,Y values of points that are clicked on.

Here is the simplest solution I can think of:
1) use mouse to click on chart point and get X,Y values (already done)
2) have a userform pop up that allows me to enter new X and Y values with the keyboard
3) replace the original X,Y values in the worksheet with the new values, and see the change on the chart
4) repeat for other points

Any help (code outline) would be appreciated.

Thanks,

Please Login or Register  to view this content.

[Joakim N]

I have attached and example in a workbook. Hope this can be helpful.

[hamang]

Hi Joakim,

Thanks for the example. I tried running on my workbook and I get an error 9 when running. Do you know what is going wrong? The code is selecting the right range for the X,Y values (columns A and B, rows 3 to 846)

Untitled.png

[Joakim N]

Hi,
It's difficult to provide help if you don't attach your workbook.

[hamang]

Hi,

Example workbook is attached.

Thanks,

[Joakim N]

Hi,

It seems that it doesn't accept your worksheet name "AB-1234 10m5m". I changed to "Test". Then it worked. Space is not allowed as character. Then VBA code has to be modified to take care of that. It seems that "-" wasn't accepted either. I tested "AB_1234_10m5m". It worked.

[hamang]

Hi,

Yes, it works fine with new name. Great - thanks for your help!