Thanks for your help guys, it worked a treat!

I dynamically created a function in my workbook, that returned a
reference to the newly created user form (ie. VBA.UserForms.Add(...)).

Once I had the reference, in my XLA, I could manipulate the controls
and finally show the form.

Thanks once again.
Cheers
Rick :-)