user forms

[sam1]

Hi,

is it possible for a user form to open automatically when the .xls doc containing it is opened?

[Chip Pearson]

Use the Workbook_Open event procedure. In the ThisWorkbook code
module, paste the following code:

Private Sub Workbook_Open()
userform1.Show
End Sub



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"sam1" <sam1.24kprn_1142195102.3195@excelforum-nospam.com> wrote
in message
news:sam1.24kprn_1142195102.3195@excelforum-nospam.com...
>
> Hi,
>
> is it possible for a user form to open automatically when the
> .xls doc
> containing it is opened?
>
>
> --
> sam1
> ------------------------------------------------------------------------
> sam1's Profile:
> http://www.excelforum.com/member.php...o&userid=18280
> View this thread:
> http://www.excelforum.com/showthread...hreadid=521537
>