Open Excel to display created forms

Borhani · January 18th, 2008, 05:19 AM

If someone could help on below issue I believe it could benifit all beginners in VBA programming ....after creating a form with some controls on the it, how to make this form open next time we open the created form in the Excel 2003 file...

I created the form Excel 2003 and saved it, and closed excel... when I reopened the file ...the spread sheet is opening and not the form I created...I want excel to open the form so user's can access information through userfriendly interface....Grateful if someone could help....Many Thanks...

Shasur · January 18th, 2008, 10:17 PM

You can call the Show method of the form in Workbook_Open event

Code:

Private Sub Workbook_Open()

UserForm1.Show

End Sub

this event will be fired whenever the Workbook is opened. Hope this is your requirement!

Cheers
Shasur

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Borhani · January 19th, 2008, 07:42 AM

Thank you I tried working great....