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: 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

 
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
Loading a Userform Chad Excel Programming 4 August 22nd 07 05:06 PM
Error on loading userform Trader Excel Programming 4 April 19th 07 05:00 PM
Range.Select error and screen maximizing error in Workbook_Open() Punsterr Excel Programming 3 May 10th 06 10:16 PM
Range.Select error and screen maximizing error in Workbook_Open() Punsterr Excel Programming 0 May 10th 06 07:56 PM
Loading UserForm gives error Mats Samson Excel Programming 3 August 3rd 05 08:06 AM


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