Hi

I have a private sub routine called 'initProductForm' and this does everything I want when called from a click event; initialises listboxes, populates listboxes, sets screen messages to blank, etc.

I want the routine to run when the workbook opens and rather than duplicate the code I would like to call the routine when the workbook opens.

How best to go about achieving this?

Thanks