mousemove(drag and drop) for spreadsheet on vba userform

[yousuf]

Hi Experts,

I have succeded in moving an image on vba userform. however, i am unble to do the same for spreadsheet as the mousemove option seems to be missing.

attaching my sheet for your reference.

Thanks

[Jan Karel Pieterse]

Getting that to work on a spreadsheet would involve:
- Using a transparent ActiveX commandbutton on the sheet in question (Easy if it is a fixed worksheet, harder if it is on different sheets)
- Adding a bunch of API functions to do the complicated tranformation of mouse coordinates to the Excel grid coordinates
- Using the mousemove event of the commandbutton to drag the other objects around.

[snb]

If you click the blue border of the spreadsheet you can drag it anywhere.