Microsoft Calendar Control

[Richard Mogy]

Hi,
I have discovered the Microsoft Calendar control and it looks like a neat
tool.

I am at a loss as to how to populate it with data from my Excel workbook.

I have a range in excel with information listed on a daily basis of hours
worked and hours billed.

I would like the use to be able to select an individual and populate the
various day in the calendar with that individuals hours worked and hours
billed


Individual Date Hours Worked Hours Billed
301 3/1/2004 3 7
301 3/2/2004 5 1
301 3/3/2004 8 9
302 3/1/2004 5 0


etc.

I'm sure this is simple, but I'm just not seeing it.

 

[Bob Phillips]

Take a look at www.rondebruin.nl/calendar.htm

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Richard Mogy]

Thank you, but I guess I didn't state my question properly. I want to be
able to take the data sample and populate the calendar with the hours billed
and worked, not the other way around, which is what the referenced web site
was doing.

 

[Tom Ogilvy]

Is this the control you are talking about:

http://www.fontstuff.com/access/acctut09.htm

 

[Tom Ogilvy]

If it is that control, it doesn't support that.

 

[Richard Mogy]

That is the control I am talking about, but others have said it doesn't
support what I want to do. Any suggestions.

 

[Richard Mogy]

That is the control -- any suggestions as to how to do what I want to do?

 

[Tom Ogilvy]

Build a userform that does what you want.