Automatic Form

  • Thread starter Thread starter alexm999
  • Start date Start date
A

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
 
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)
 
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
 
Back
Top