Link to home
Start Free TrialLog in
Avatar of efarhat
efarhat

asked on

Unable to load UserForm on Excel Startup

Does anyone know how to load a UserForm in the Workbook_Open subprocedure of an Excel Application?
ASKER CERTIFIED SOLUTION
Avatar of aelatik
aelatik
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of efarhat
efarhat

ASKER

should it be modeless?
Avatar of efarhat

ASKER

also, on my command buttons.. i thought if you add "%Caption" it will make the "C" a shortcut?
"&Caption" will make it a shortcut.
should it be modeless? >>>>

That is something you need to decide, if you want the user to be able to edit while the form is running then use Model otherwise not
Avatar of efarhat

ASKER

& doesn't work in Excel. is it a bug?