Starting a VB form when sheet is open

[celltician]

I created a form and module in Excel VBA.
How do I cause it to start when the worksheet containing it starts?

Hope I am asking the correct question. I am used to programming in VB 6.0. You specify a form or main module as the startup in VB. Can't figure out how to do that in VBA.

Thanks.

 

[_denis_]

use the macro below, you must call the macro auto_open


Sub auto_open()


' auto_open Macro
' Macro recorded 28-10-01 by DENIS MCCARTHY

UserForm1.Show

End Sub

 

[celltician]

Thank you very much.