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

The equivalent macro name in Excel is Auto_Open.

--
Jim
"parkin_m" <(E-Mail Removed)> wrote in message
news:7F150E0E-9502-46C7-B0A9-(E-Mail Removed)...
|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

AutoNew is the name of the MSWord macro.

In excel, you can use Auto_Open (in a general module) or Workbook_Open (in the
ThisWorkbook module).



parkin_m wrote:
>
> 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

--

Dave Peterson