B
Balan
I am preparing a user form. I am facing the following two problems:
i) I want the user form to load when workbook is opened. Under ThisWorkbook
< workbook < Open, I have written frmxyz.show. Still the form is not
showing. I am getting Error 424: Object required. I tried to check where
the mistake could be. I am unable to locate it. The name of user form
'frmxyz' is appearing in the project window. Still I do not why the
programme is unable to locate it. Kindly help me understand the problem.
ii) In one of the text boxes of the user form, I want dates to entered in
the format mm/dd/yyyy. How to do it and how to ensure that the slash '/'
marks between mm, dd and yyyy automatically appear when the user form is
loaded so that the user will automatically know that he has to fill in dates
only.
Thanks in advance.
i) I want the user form to load when workbook is opened. Under ThisWorkbook
< workbook < Open, I have written frmxyz.show. Still the form is not
showing. I am getting Error 424: Object required. I tried to check where
the mistake could be. I am unable to locate it. The name of user form
'frmxyz' is appearing in the project window. Still I do not why the
programme is unable to locate it. Kindly help me understand the problem.
ii) In one of the text boxes of the user form, I want dates to entered in
the format mm/dd/yyyy. How to do it and how to ensure that the slash '/'
marks between mm, dd and yyyy automatically appear when the user form is
loaded so that the user will automatically know that he has to fill in dates
only.
Thanks in advance.