Solved: Calendar control not working
I have built a Word form that includes a field that that holds a date.
When you tab into the field, a response box pops up and asks "today" yes or no. If the answer is yes, the field is filled with today?s date. If no, a drop down calendar (frmCalendar.show) appears and the date can be chosen from that calendar.
So with some help from the Word help forum, I got the form to work. The problem is that it won't work on a Mac. The intent is to use mostly on PCs but there will be times that the file will be needed on the mac. I would also like to use this funtion on some other forms.
Can the calendar control work for the Mac? Could some VB code solve the problem? Is there any way one solution could work for both Mac and PC? Are there any suggestions?
Any suggestions and help are appreciated.
I'll see if I can make this work for me. Thank you
I'll follow your directions and try to incorporate this into a copy of my working file. If it works well, I'll be very thankful.
It also looks like many other will prosper form your work.
Nice job and thank you,
userform calendar control
Hey guys,
I found this some time back and have been using it exclusivly. Even in Windows the native calendar control is not portable if they don't have the control in the system where you move it.
Works on sheet code but only pops up if you click a cell with a specific format.
might work on mac-don't know but worth a look.
This one is for excel
Did you put it all together in a file
Bluecactus, Thank you again for all the help. In one of your original replies, you mentioned that you couldn?t upload the file. Has that changed? Can you wrap this up and post it. I did what you said and I'm having some success, but...
Was wondering?
Thank you again.
Thank you, project appears complete
Especially BlueCactus.
The document is complete with the needed code for the calendar.
Should I mark the thread closed???? It appears to still be getting a lot of usefull comments and suggestions. I wouldn't want to close out anything that was still usefull.
Admin, please advise.
Richard