[Solved] VBA: Creating event handlers at run time

Any suggestions as to how I might do this?

Basically I am dynamically generating a number of controls on a form at run time and want each of them to handle to the mouse move event. I cannot find a way to do this, other than by creating them all in design mode and adding code to the MouseMove event. I cannot use this method though as the number of controls is determined by the user at run time.

Any thought greatly appreciated

Andy,

This is exactly what I was after, thank you very much! (took me a wile to realise I hadn't referenced MS Forms 2.0 Object Library :banghead: )

I can feel a whole new world of irritatingly interactive forms coming on :biggrin:

Cheers!