Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Display user form when Excel opens using VBA
- Thread starter speedbump
- Start date
Not 100% sure if I understand the question, but assuming I do, here's the answer:
open up the workbook
open up vba editor for that workbook
in the Workbook_Open() method of thisSheet add:
myform.show
Where myform is the name of the form you would like to have displayed automatically.
-Venkman
open up the workbook
open up vba editor for that workbook
in the Workbook_Open() method of thisSheet add:
myform.show
Where myform is the name of the form you would like to have displayed automatically.
-Venkman
- Status
Similar threads
- Question
- Locked
- Question
