Starting a VB form when sheet is open

celltician · Feb 27th, 2002, 12:57 PM

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_ · Feb 27th, 2002, 01:10 PM

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 · Feb 27th, 2002, 01:20 PM

Thank you very much.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 27th, 2002, 12:57 PM	#1
celltician New Member Join Date: Feb 2002 Location: Wisconsin Posts: 9	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.

Feb 27th, 2002, 01:10 PM	#2
_denis_ Board Regular Join Date: Feb 2002 Posts: 103	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

Feb 27th, 2002, 01:20 PM	#3
celltician New Member Join Date: Feb 2002 Location: Wisconsin Posts: 9	Thank you very much.