User Form - how to load it

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Balan - 17 May 2008 18:26 GMT

I have developed a user form. How to ensure that it gets loaded when ever I
open the workbook ?

Reply to this Message

Chip Pearson - 17 May 2008 18:39 GMT

In the ThisWorkbook code module, use something like

Private Sub Workbook_Open()
UserForm1.Show
End Sub

Signature

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

>I have developed a user form. How to ensure that it gets loaded when ever
>I
> open the workbook ?

Reply to this Message

Balan - 18 May 2008 03:43 GMT

Many thanks !

> In the ThisWorkbook code module, use something like
>
[quoted text clipped - 5 lines]
> >I
> > open the workbook ?

Reply to this Message

Balan - 20 May 2008 04:19 GMT

Sorry trouble you again. I am getting error msg 424 " Object Required" when
ever I tried to open the workbook. I tried to check the name of the
workbook, spelling used in Private Sub Workbook_Open(). I am not able to
trace the problem. What could be the reason, please ?

Balan

> In the ThisWorkbook code module, use something like
>
[quoted text clipped - 5 lines]
> >I
> > open the workbook ?

Reply to this Message

Dave Peterson - 20 May 2008 12:39 GMT

Did you change the name of the Userform? If you did, then you'll have to use
its new name in your code, too.

If this doesn't help, what's the name of the userform?

And post the code that causes the error--maybe it's not the Workbook_Open
event???

> Sorry trouble you again. I am getting error msg 424 " Object Required" when
> ever I tried to open the workbook. I tried to check the name of the
[quoted text clipped - 21 lines]
> > >I
> > > open the workbook ?

Signature

Dave Peterson

Reply to this Message