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
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.
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
Thank you very much.
Like this thread? Share it with others