vba start up

dantb · Mar 25th, 2002, 02:02 PM

Can a vba form be made to start automaticaly, when the work book is open ?

Jack in the UK · Mar 25th, 2002, 02:44 PM

try adding the script into Auto_Open see help files in VBE not bad stuff..

This will run as book is opened.

what you wanted?

Tom Schreiner · Mar 25th, 2002, 06:33 PM

Hi
If the name of your form is form1 use the following syntax

form1.show

Should look like the following:

Private Sub Workbook_Open()
form1.show
End Sub

Mar 25th, 2002, 02:44 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	try adding the script into Auto_Open see help files in VBE not bad stuff.. This will run as book is opened. what you wanted? __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

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

Mar 25th, 2002, 02:02 PM	#1
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	Can a vba form be made to start automaticaly, when the work book is open ?

Mar 25th, 2002, 06:33 PM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi If the name of your form is form1 use the following syntax form1.show Should look like the following: Private Sub Workbook_Open() form1.show End Sub