Why are you calling the userform's Initialize event?
Why not just use Show?
I wrote a program in Excel that calls a form to load when an action happens on a spreadsheet page, the code I used to call the form from is
however since upgrading to MSoffice 2003 i get the runtime error '53' file not found. the files still their...? any ideas?VB:sqe_portal.UserForm_Initialize
Can you post the full initialise code?
Hope that Helps
New users should read the Forum Rules before posting
For free Excel tools & articles visit my web site
If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need
RoyUK's Web Site
royUK's Database Form
Where to paste code from the Forum
the show command brings up the same error.
the code is in place to bring up the user form 'sql_portal' when the workbook is opened.
is their another way I can get the form to load on startup?
Last edited by mathewjenkinson; January 24th, 2007 at 01:14.
There are currently 1 users browsing this thread. (0 members and 1 guests)