View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Minitman[_4_] Minitman[_4_] is offline
external usenet poster
 
Posts: 273
Default UserForm Wont Load

Hey Dick,

Thanks for that advice, that did indeed bring up more information.

The VB message box was the same. However, the debugger came up with
this:

Private Sub UserForm_Initialize()
Dim i As Integer
Application.ScreenUpdating = False
Sheets("CI").Activate
lastrow = Range("A65536").End(xlUp).Row
For i = 1 To lastrow
GetCustInfo_ListBox_01_04.AddItem Cells(i, 1) <<<

Next i
Application.ScreenUpdating = True
Sheets("Enter").Activate
End Sub

What I still don't understand is why it only has problems in the newer
version and works fine in the older!!!!

Any ideas????

-Minitman
On Mon, 26 Apr 2004 17:40:44 -0500, "Dick Kusleika"
wrote:

Minitman

It looks like you're saying the debugger highlights the Show line. If so,
go to Tools - Options - General (in the VBE) and select "Break in Class
Modules" in the Error Trapping section. Whenever an error ends on a class
instancing line (like Show) it usually means the error is in the class
module (the userform module, in this case) but that error trapping isn't set
to go there. This will tell you which line is actually causing the error.