Automatic Form

[alexm999]

I have a form that i'd like to automatically open evertime someone open
open sheet1 (worksheet).

Can this be done? If so, how

 

[Bob Phillips]

Alex,

Yes, sheet activate

Private Sub Worksheet_Activate()
Userform1.Show
End Sub


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[teatree]

1) right click on the tab for the sheet that you want to have the actio
apply to

2) click "View Code"

3) this should pop you into the vbe in a macro called "Private Su
Worksheet_SelectionChange"

4) replace that macro with this: (replace "UserForm1" with the name o
your Userform. This assumes that you have created the Userform in th
VBE, rather than a custom dialog box, like you used to do in Excel 95)

'begin code

Private Sub Worksheet_Activate()
UserForm1.Show
End Sub

'end code

5) save, close editor

now whenever anyone activates the worksheet, the userform will pop up