Andrew - yes thanks that worked - I knew it must be simple.
Funny thing is, I could not see any events available in the codes right hand drop down list - just the word (Declarations). When I created the UserForm_Initialize event manually suddenly there were a whole load of other events available such as Activate, AddControl etc.
Had I been able to see this list when the form was first created without any code, it would have been obvious.
|