LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default SOme problem on VBA Userform

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 a

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 a

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

--
Message posted from http://www.ExcelForum.com

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Userform problem? law Excel Discussion (Misc queries) 0 December 3rd 07 07:54 PM
userform problem TUNGANA KURMA RAJU Excel Discussion (Misc queries) 0 August 10th 06 04:43 AM
UserForm Problem mayuss Excel Programming 3 August 9th 04 01:18 PM
excel vba- userform problem knight4[_3_] Excel Programming 1 February 25th 04 02:36 PM
Userform Problem Todd Huttenstine Excel Programming 2 February 15th 04 09:54 PM


All times are GMT +1. The time now is 07:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"