A
allissonlu
Hi,
I am using Excel 2002, and I am new to VBA in Excel.
I created a userform (named frmCost) within an Excel file, and on on
of the Excel sheets, I added a button (called BtnStart) to control th
loading of the userform.
The codes are:
Private Sub BtnStart_Click()
Dim frmCostCal As New frmCost
With frmCostCal
.Show
End With
End Sub
Also on the userform, I added an "exit" button to unload the userfor
and return to Excel. The codes are:
Private Sub btnExit_Click()
Unload Me
End Sub
The problem is, sometimes when I click the "Start" button, the Exce
crashes. This happens randomly, esp. when the button is clicked righ
after opening the Excel file.
Any help or advice will be highly appreciated.
Alliso
I am using Excel 2002, and I am new to VBA in Excel.
I created a userform (named frmCost) within an Excel file, and on on
of the Excel sheets, I added a button (called BtnStart) to control th
loading of the userform.
The codes are:
Private Sub BtnStart_Click()
Dim frmCostCal As New frmCost
With frmCostCal
.Show
End With
End Sub
Also on the userform, I added an "exit" button to unload the userfor
and return to Excel. The codes are:
Private Sub btnExit_Click()
Unload Me
End Sub
The problem is, sometimes when I click the "Start" button, the Exce
crashes. This happens randomly, esp. when the button is clicked righ
after opening the Excel file.
Any help or advice will be highly appreciated.
Alliso