View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rjchristensen rjchristensen is offline
external usenet poster
 
Posts: 3
Default VB Error 5 loading userform using Workbook_Open

I'm new to writing VBA for the Excel environment so bear with me. I
am trying to get a user form called "DispBoard" to load/display using
the Workbook_Open area and I keep getting the VB Runtime Error 5. The
code was added the the "ThisWorkbook" section of Microsoft Excel
Objects in the VBA project. I tried both of the following calls and
they both produce the same error. Any suggestions would be most
appreciated.

Thanks,

Rich

Example 1:
======================
Private Sub Workbook_Open()
DispBoard.Show
End Sub


Example 2:
======================
Load DispBoard
Private Sub Workbook_Open()
DispBoard.Show
End Sub