How to synchronise movement of a userform and the spreadsheet application behind

I have a userform that, through the use of API functions, allows me a 'window' right through the form so that I can view a chart sitting on the spreadsheet behind it. I've done this for speed. The chart is complex and the traditional 'export - upload image file to userform' approach, for each update of the chart, was simply taking too long.

My problem is that when I drag the userform around the screen the excel application/spreadsheet behind it remains static, so I lose the position of the chart through the userform window. Does anyone know a way to synchronise a userform and the spreadsheet application behind it, so that if the user drags the userform around the screen, the excel application moves with it?

Many thanks

Farnsbarnes

Hi Norie

I was afraid you'd say that. A guru supplied me with the API code for the userform, but my real understanding of API functions it is almost nothing! Would you be able to provide some code to do this?

I'll also take a look at MS Chart Control, but again brand new to me.

Sure, I've attached the concept of the userform containing a window to the chart behind it. Click on 'Show userform' and you'll see what I mean

Thanks

Anyone interested in having a go at this?