auto load the VBA~

[-_-\]

how to set the VBA autoload when i open the excel file ~?!
thx a lot~~

[Bob Phillips]

The question doesn't make sense, VBA is there with Excel.

If you want to run a macro when the workbook opens, name it Auto_Open.

--
HTH

Bob Phillips

"-_-"" <[email protected]> wrote in message
news:uWbrs%[email protected]...
> how to set the VBA autoload when i open the excel file ~?!
> thx a lot~~
>
>

[-_-\]

thank you~
But i am still confused in VBA and macro.
I used the visual basic editor to create a form.
and how can I open the form (ie run sub/userform) when i open the
workbook.~?

Thx again~
"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> The question doesn't make sense, VBA is there with Excel.
>
> If you want to run a macro when the workbook opens, name it Auto_Open.
>
> --
> HTH
>
> Bob Phillips
>
> "-_-"" <[email protected]> wrote in message
> news:uWbrs%[email protected]...
>> how to set the VBA autoload when i open the excel file ~?!
>> thx a lot~~
>>
>>
>
>

[Bob Phillips]

Sub Auto_Open()
Userform1.Show
End Sub

--
HTH

Bob Phillips

"-_-"" <[email protected]> wrote in message
news:[email protected]...
> thank you~
> But i am still confused in VBA and macro.
> I used the visual basic editor to create a form.
> and how can I open the form (ie run sub/userform) when i open the
> workbook.~?
>
> Thx again~
> "Bob Phillips" <[email protected]> wrote in message
> news:[email protected]...
> > The question doesn't make sense, VBA is there with Excel.
> >
> > If you want to run a macro when the workbook opens, name it Auto_Open.
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > "-_-"" <[email protected]> wrote in message
> > news:uWbrs%[email protected]...
> >> how to set the VBA autoload when i open the excel file ~?!
> >> thx a lot~~
> >>
> >>
> >
> >
>
>

[-_-\]

Done~ thx a lot~
"Bob Phillips" <[email protected]> wrote in message
news:%23lvtx%[email protected]...
> Sub Auto_Open()
> Userform1.Show
> End Sub
>
> --
> HTH
>
> Bob Phillips
>
> "-_-"" <[email protected]> wrote in message
> news:[email protected]...
>> thank you~
>> But i am still confused in VBA and macro.
>> I used the visual basic editor to create a form.
>> and how can I open the form (ie run sub/userform) when i open the
>> workbook.~?
>>
>> Thx again~
>> "Bob Phillips" <[email protected]> wrote in message
>> news:[email protected]...
>> > The question doesn't make sense, VBA is there with Excel.
>> >
>> > If you want to run a macro when the workbook opens, name it Auto_Open.
>> >
>> > --
>> > HTH
>> >
>> > Bob Phillips
>> >
>> > "-_-"" <[email protected]> wrote in message
>> > news:uWbrs%[email protected]...
>> >> how to set the VBA autoload when i open the excel file ~?!
>> >> thx a lot~~
>> >>
>> >>
>> >
>> >
>>
>>
>
>