I have a excel document which contains a template for an invoice.

I am going to create a userform in excell which will show itself whenever a
new document is created, allowing the user to pick a client name and then
select an address which will then populate the excel document.

I have done this before using word where i did:

(in autonew macro)
userform1.show

(in userform1 form)
//do vba code to enter information

I tried to do this using excell but autonew macro doesnt seem to self
execute like in word. Is there a simple solution?

Thanks