adaytay
New Member
- Joined
- Nov 27, 2003
- Messages
- 47
Hi all, it's been a while! Had an unusual request in from a client, and thought I'd post up here as it's something I don't even know if is possible.
A client has a spreadsheet with a table of data and a chart. Updating two cells with new latitude and longitude co-ords moves the position of an item on the chart - which is basically a map of the ocean.
My client wants to be able to do the updating in reverse, i.e. click/drag the item on the chart and move it to a new location, which then updates the values in the worksheet.
Is this possible? I suspect it might be, but it'll need a fair bit of VBA to do (which I'm comfortable with, just need to know if it's do-able at this stage!)
Any links to useful sites, articles or whatever would be gratefully received - I'm googling like mad here!
Thanks in advance,
Ad
A client has a spreadsheet with a table of data and a chart. Updating two cells with new latitude and longitude co-ords moves the position of an item on the chart - which is basically a map of the ocean.
My client wants to be able to do the updating in reverse, i.e. click/drag the item on the chart and move it to a new location, which then updates the values in the worksheet.
Is this possible? I suspect it might be, but it'll need a fair bit of VBA to do (which I'm comfortable with, just need to know if it's do-able at this stage!)
Any links to useful sites, articles or whatever would be gratefully received - I'm googling like mad here!
Thanks in advance,
Ad
