-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Open graphic calendar on cell click
- Thread starter craigwojo
- Start date
Excel Facts
VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
I'm back.
Sorry for bothering you. Just need a little direction on what needs to me done with the VBA area. When I used the original VBA for the calendar I had files to insert.
ie.
- frmCalendar.frm
- modCalendar.bas
- clsLabel.cls
Craig
Attachments
Last edited:
Upvote
0
Actually, you don't have to worry about those files. You would only use them if you were going to import them into your VBA project. At this point, though, you can simply delete the existing code in each of the modules (except clsLabel, since the code there hasn't changed), and replace them with their respective code I posted. Oh, and of course, you would have to insert a new module, and add the new code I posted for it in my previous post. That's it. Then you should be good to go. 
Last edited:
Upvote
0
Thank you Domenic. I'll give it a try today.Actually, you don't have to worry about those files. You would only use them if you were going to import them into your VBA project. At this point, though, you can simply delete the existing code in each of the modules (except clsLabel, since the code there hasn't changed), and replace them with their respective code I posted. Oh, and of course, you would have to insert a new module, and add the new code I posted for it in my previous post. That's it. Then you should be good to go.
Upvote
0
Hi Craig,
Hopefully you've been able to get it to work. In any case, I've updated the sample workbook...
Hope this helps!
Hopefully you've been able to get it to work. In any case, I've updated the sample workbook...
Date Picker | xl-central.com
Displays a calendar, and prompts the user to select a date.
xl-central.com
Hope this helps!
Upvote
0
Upvote
0
