combining calender dates with a Box In Excel

Microsoft Microsoft excel 2007 (pc)
March 23, 2010 at 03:49:01
Specs: Windows 7

I want to ccreate a calender which shows all
the months, days and dates.

And when one click on a day of the month
another box shows which explanes the task of
the day.

One should be able to combine different data
with different dates.

The box is on the same sheet as the calender.

i.e. : Clicking on Thurday jan. 21. 2010, on the
calender, the boxs shows information on tasks
etc. done that specific day

See More: combining calender dates with a Box In Excel

March 23, 2010 at 05:23:18
re: Clicking on Thurday jan. 21. 2010, on the calender, the boxs shows information on tasks etc. done that specific day

This makes sense, although it would be helpful to know the extent of the "tasks" for that day. Are we talking about pages of tasks or a simple task like "Back Up Data"?

re: One should be able to combine different data with different dates.

What does this mean?

Report •

March 24, 2010 at 03:05:11
When you click on a specific date, then the attached box should
show the data which you have entered earlier.

The data of the specific date should envolve time consumtion on
each task and generel task information.

Report •

March 24, 2010 at 05:42:44

If you are using Outlook, it comes with a calendar and maybe that would be easier than building something in Excel.

Also there are small calendar apps available - like this one from Gregory Braun that lets you put reminders in any date - either as single reminders or as repeating reminders, including repeating say 1st Monday of each month.

If you still want to go down the Excel route, you can add a complete calendar to a spreadsheet. Excel has a built-in calendar.

I do not have Excel 2007 on this PC, so I can't test this now or walk you through it, but from memory, try this:
From the Ribbon select Developer (If it's not visible go to the Office Button, select Excel options at the bottom and select the Popular tab and check the 'Show Developer tab in the Ribbon' box)

In Developer - Controls select Insert and choose the Calendar Control - If it is not visible, click the additional controls icon - then find 'Calendar Control'. Select the control and draw it on the worksheet.

Resize the Calendar, then right-click and select Properties to change things such as font.

Right-click again and select 'View code' to add VB code to the control.

The calendar control allows you to use the date of the day selected by the user. Use the date to pop-up a message box with information based on the date selected.


Report •

Related Solutions

March 24, 2010 at 06:21:14
While I agree with Humar that reinventing a calendar app within Excel might not be the best path, it could be done with something as simple as this:

1 - Set up Sheet1 so that it looks like a calendar page.

2 - In Sheet2, place the tasks for each day in the same cell as the matching date on Sheet1. i.e. if May 10th is in Sheet1:B4, put the tasks for May 10 in Sheet2:B4.

3 - Right Click the tab for Sheet1, choose View Code and paste this macro into the pane that opens:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
 MsgBox Sheets(2).Range(Target.Address)
End Sub

When you select a date on Sheet1, a MsgBox with the data from the same cell on Sheet2 will pop up.

Note: I'm not necessarily recommending this method...I'm just throwing it out as an idea of how it could be done.

To take it a step further, the cell in Sheet2 could contain a hyperlink to a document (or place in a document) and the SelectionChange code could follow that link to display the data.

For that matter, the date on Sheet1 could be a hyperlink to the tasks.

Report •

March 25, 2010 at 01:36:08
thx for all the input it's much apreciated.

@derbydad03; if not in Excel which tool would u recommend?

Report •

March 25, 2010 at 05:33:12
I don't have a recommendation because I don't know enough about the multitude of calendar apps that are available.

I use ACT! and Outlook at work, but only because they are what I am required to use by my company (Outlook) and my team (ACT!).

Report •

Ask Question