Auto Open UserForm

**garretonufer** · 09-29-2009, 11:33 AM

If i have a userform: frmUpdateInfo

How do i have it auto open or at least be ready for use when going to a particular sheet in a workbook (Sheet name: "Matches")

thanks in advance.

**Andy Pope** · 09-29-2009, 11:38 AM

Right click the sheets tab and pick View Code.
Use the Activate event to show userform

Please Login or Register  to view this content.

**garretonufer** · 09-29-2009, 11:46 AM

Fantastic, is there anyway to have it hide when selecting different sheets so that the form only appears in this sheet and this sheet alone?

**Palmetto** · 09-29-2009, 11:53 AM

In the same worksheet and following Andy's instructions:

Please Login or Register  to view this content.

**garretonufer** · 09-29-2009, 11:57 AM

you folks are awesome, thank you.

**Andy Pope** · 09-29-2009, 11:59 AM

This means you must be showing the userform Modeless otherwise the user would not be able to change sheet without closing the userform first, yes?

**garretonufer** · 09-29-2009, 12:41 PM

with the

Please Login or Register  to view this content.

works perfect. The user can change sheets at their leisure and they will only see the form in that particular sheet. They are not required to close it out before changing sheets.