Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Error 5 loading userform using Workbook_Open
I've never experienced any problems with this.
Maybe your userform isn't called dipboard? Maybe its the CAPTION of the userform you have named and NOT the (name) of the userform. Try this Sub Auto_Open Userform1.show 'Or 'Load Userform1 'Or change userform1 to dipboard End Sub If this isn't your problem I will be stumpt, unless you have imported the userform -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200710/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loading a Userform | Excel Programming | |||
Error on loading userform | Excel Programming | |||
Range.Select error and screen maximizing error in Workbook_Open() | Excel Programming | |||
Range.Select error and screen maximizing error in Workbook_Open() | Excel Programming | |||
Loading UserForm gives error | Excel Programming |