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: 683
Default Excel Crashes when trying to open a User Form

When I open the workbook and click on the worksheet to open the user form
excels stops working. I get Microsoft Office Excel has stopped working and is
trying find a solution, but it never does.

I have saved it in both 2007 & 2003 versions and both get the same problem.
What is odd is if you open the Userform Workbook, then open the VBA code
window, both userform versions run fine, but if you do not open the Code
window Excel locks up everytime.

Here is the code.

Sheet 2 Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
UserForm1.Show
End Sub

UserForm1 Code:
Private Sub UserForm_Initialize()

With Me.Address_21
.AddItem "1"
.AddItem "2"
.AddItem "3"
.AddItem "4"
.AddItem "5"
End With
End Sub
 
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
Excel crashes depending on user?? Khuli Excel Discussion (Misc queries) 0 June 17th 09 11:04 AM
See User Form On Open wx4usa Excel Discussion (Misc queries) 13 October 23rd 08 02:56 PM
Open a user form Pietro Excel Discussion (Misc queries) 1 August 29th 07 12:03 PM
use a button to open a user form? Hru48 Excel Discussion (Misc queries) 1 September 1st 05 07:41 PM
vbModeless user form crashes Excel Plutopotamus Excel Programming 2 January 28th 05 03:19 PM


All times are GMT +1. The time now is 06:15 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"