[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:


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!