Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 683
Default UserForm1UserForm1_InitializeProblem with Office 2007

I am having a problem getting my User Form to Initialize.

3 Days ago the Code was fine and opened and ran fine. Nothing in the code
has changed, but now trying to open the User Form Locks up Excel. If you open
Excel and then open the User Form Workbook, Click on the Page to display the
User Form Excel Locks up.

Now repeat the same steps, but this time open the VBA Editor first, then
display the User Form, it runs fine. Has anyone else had this Problem with
Office 2007? If so how can I fix it?

Code on the Worksheet Page:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
UserForm1.Show
End Sub


Code in the User Form Code Window.
Private Sub UserForm1_Initialize()

'================================================= ===
'Written Office
With Me.Address_21
.AddItem "AA"
.AddItem "AB"
.AddItem "AC"
.AddItem "AD"
.AddItem "AE"
End With
'================================================= ==
'Engineer
With Me.Engineer_2
.AddItem "AF"
.AddItem "AG"
.AddItem "AH"
.AddItem "AJ"
.AddItem "AK"
.AddItem "AL"
End With
'================================================= ==
' Equipment Engineer
With Me.Engineer_3
.AddItem "AM"
.AddItem "AN"
.AddItem "AP"
.AddItem "AQ"
.AddItem "AR"
End With

End Sub

Reply
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
Install Office Standard XP on Vista. Uninstall Office 2007 Trial? Machete Excel Discussion (Misc queries) 1 August 11th 09 03:54 AM
Installing a Vista Office 2007 developed XLA to XP office 2003 machine Ed Sowell Excel Programming 4 February 27th 09 08:25 PM
Office 2007 compatibility pack on Office 2003 (slow network file fox_mulder33 Setting up and Configuration of Excel 0 January 2nd 08 03:28 PM
Problem with Interop.Excel after uninstalling Office 2007 and installing Office 2003 Bill F[_2_] Excel Programming 2 May 2nd 07 02:52 PM


All times are GMT +1. The time now is 12:55 AM.

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"