Hi gurus,
Instead of excel, I'm working on Microsoft word userform. I just want to have a Calendar Form without using any addins. I've googled it but all I've search is excel-based.
Hope anyone can help me with this.
Thanks in advance gurus!
Hi gurus,
Instead of excel, I'm working on Microsoft word userform. I just want to have a Calendar Form without using any addins. I've googled it but all I've search is excel-based.
Hope anyone can help me with this.
Thanks in advance gurus!
Hi puuts,
Here is a stand alone calendar written by Leith Ross that you might use.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Will try this Marvin!
Will keep you updated if I've encounter some errors.
Hi Marvin,
I'm encountering an error on this line:
Since I'm not in Excel, is there any way to change the above?Please Login or Register to view this content.
Hi puuts,
The Calendar code was written to work with Excel and not word. The line that is giving an error is telling the code to put the selected date back into Excel in the cell. I have no idea where you want the date inserted into Word. I don't even know if you want to pass back a selected date at all. Put a "Rem" in front of the line that is giving an error and try again. If you only want to view the calendar then this simple change might work.
I've commented it and it still gives me the same error. I'm thinking instead of activecell, I will declare the variable to hold the value, but I can't figure it out.
In Word there are no ActiveCells. You need to Rem out or change all the code that is specific to Excel if you want to display and use the Userform in Word.
To declare a variable to hold that date use:
Dim FoundDate as Double
And then instead of
ActiveCell.Value = Control.Tag
try
FoundDate = Control.Tag
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks