Gee, I cannot find the cause of the error with Workbook_Open in VBA
I've checked the spelling but they seem to be right
I was trying to make userform1 appear when open the workbook if date is overdue for trucks services.
Can anyone find any fault in this one?
ThanksKen Vehicle service.xls
Last edited by unley; 09-24-2009 at 08:05 PM.
Hello Unley,
I add these macros to the attached workbook. Your macro "duedate" needed to be in a standard module, not the Worksheet to be visible on Workbook_Open.
Please Login or Register to view this content.Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thank you very much Leith for your quick reply, works perfect. As always, I'm learning in the hard way. Much appreicated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks