Hey there, I have a monthly calendar workbook that contains two sheets. The first sheet is a data table and the second sheet is the monthly calendar which displays the data from the table. I have userforms that make data entry easy. I cannot figure out how to make the calendar display the data with the cell’s full color equal to the value of the “Color Code” column in the table. Also, when I click on a date to start editing the data, the userform messes up the date format.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
VBA Calendar Help
- Thread starter dtek
- Start date
dtek
As a new member,
You have forgotten few basic things: Use Relevant words in the Title and in the tag Box, This will aid future searches.
You should reread Forum Rules
As a new member,
You have forgotten few basic things: Use Relevant words in the Title and in the tag Box, This will aid future searches.
You should reread Forum Rules
Site Rules - New Users - Please Read
Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
BobBridges
Active Member
Dtek, I glanced at your workbook but I don't see the table you speak of, the one that specifies colors. You'll have to steer me a little.
BobBridges
Active Member
The first sheet is named "Activity Planner"? I see no column there named "Colors", but column I is headed "Color Code"; is that the one you mean?
And I suppose that somewhere in your code you select a row from the worksheet Activity Planner, get the color code from that row, and then try to apply that code to a part of the calendar. But where in the code does that happen? There's a lot of code there, and it isn't obvious to me where you're attempting to set the color in the calendar. What module and procedure is that in?
And I suppose that somewhere in your code you select a row from the worksheet Activity Planner, get the color code from that row, and then try to apply that code to a part of the calendar. But where in the code does that happen? There's a lot of code there, and it isn't obvious to me where you're attempting to set the color in the calendar. What module and procedure is that in?
Sorry Bob, I haven’t been on my computer until now.
If you hit the “Add New” button on Sheet1(“Activity Planner”), a userform pops up. You enter all the data you want on the userform and hit “Select Color” to make a color picker popup. Select your color then hit “Add”.
The data is then exported to the table also on Sheet1(“Activity Planner”). The color that you selected is saved in Column “I” named “Color Code”.
What I’m trying to do is have that color code display with the event on the “Calendar” sheet. Right now, the color is set by condition formatting instead of being set by code. Also, when I click on an event to edit the data, the date format is all messed up.
I’ve attached a new workbook that has some test data already entered into the table.
Thank you,
If you hit the “Add New” button on Sheet1(“Activity Planner”), a userform pops up. You enter all the data you want on the userform and hit “Select Color” to make a color picker popup. Select your color then hit “Add”.
The data is then exported to the table also on Sheet1(“Activity Planner”). The color that you selected is saved in Column “I” named “Color Code”.
What I’m trying to do is have that color code display with the event on the “Calendar” sheet. Right now, the color is set by condition formatting instead of being set by code. Also, when I click on an event to edit the data, the date format is all messed up.
I’ve attached a new workbook that has some test data already entered into the table.
Thank you,
Attachments
BobBridges
Active Member
I see the sheet named "Activity Planner", but I don't see a button on it labeled "Add New".
But regardless, I wasn't asking what actions the user might take to get to the part of the code that attempts to change the color. I'm asking where in the code it happens. What is the name of the module and procedure? I don't know where to look for it. If I see the part of the code that isn't working right, maybe I'll be able to see what you're doing wrong.
But regardless, I wasn't asking what actions the user might take to get to the part of the code that attempts to change the color. I'm asking where in the code it happens. What is the name of the module and procedure? I don't know where to look for it. If I see the part of the code that isn't working right, maybe I'll be able to see what you're doing wrong.