allansanjan
New Member
- Joined
- Jan 4, 2022
- Messages
- 5
- Office Version
- 2007
- Platform
- Windows
Hi guys, i cant get my userform auto-run/show when i open my excel file. Thanks in advance, i try to run it, all works fine.
My excel file is saved as .xlsm (enabled)
I have a Module1 (aznoltestmacro): i have done it and works perfectly,
UserForm1 codes are as below:
My excel file is saved as .xlsm (enabled)
I have a Module1 (aznoltestmacro): i have done it and works perfectly,
UserForm1 codes are as below:
VBA Code:
Private Sub CommandButton1_Click()
UserForm1.Show
Call aznoltestmacro
MsgBox "Report Done!", , "Report Progress"
End Sub
Private Sub CommandButton2_Click()
Unload Me
End Sub