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.

 

[-_-\]

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]

Sub Auto_Open()
Userform1.Show
End Sub

 

[-_-\]

Done~ thx a lot~

Sub Auto_Open()
Userform1.Show
End Sub