I have a tab that I have named "ScheduleOfValues" (sheet 5). What I would like to have it do, is when I click on the tab to open it I would like to have a message box open so I can enter the date and users name in it and have the date be placed in "B3" and have the name of the user entered in "B6".
I really apprciate all the help I get from this forum.
Right-click the tab and select VIEW CODE, then put this event code into the sheet module:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thank you very much. It works great. The one thing that I didn't think about is, If I want to click on cancel the box will stay closed.
So it's ok to use this sheet without updating those values? Or only updating one? That's what would happen if we enabled the CANCEL option.
Yes it would be Ok to use this sheet without updating those values. I have to review other tabs sometimes when using this one. Thanks for your help on this.
OK, this will now accept any date after 1/1/1920 and any string for user. If you fail to enter either value it will simply abort and not update the current values.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.Please Login or Register to view this content.
Thank you works great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks