VBA 載入、顯示表單

Sub btn1_Click()
    Load the_form
    the_form.Show
End Sub

"找不到方法或資料成員" 時改用如下

Sub btn1_Click()
    UserForms.add("the_form").Show
End Sub

Reference :
VBA: Show or load a form when Excel starts
Excel VBA UserForm Will Not Load Or Show