|
Microsoft Calendar Control
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. |
Microsoft Calendar Control
Take a look at www.rondebruin.nl/calendar.htm
-- HTH RP (remove nothere from the email address if mailing direct) "Richard Mogy" wrote in message m... 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. |
Microsoft Calendar Control
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. "Bob Phillips" wrote in message ... Take a look at www.rondebruin.nl/calendar.htm -- HTH RP (remove nothere from the email address if mailing direct) "Richard Mogy" wrote in message m... 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. |
Microsoft Calendar Control
Is this the control you are talking about:
http://www.fontstuff.com/access/acctut09.htm -- Regards, Tom Ogilvy "Richard Mogy" wrote in message m... 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. |
Microsoft Calendar Control
If it is that control, it doesn't support that.
-- Regards, Tom Ogilvy "Richard Mogy" wrote in message om... 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. "Bob Phillips" wrote in message ... Take a look at www.rondebruin.nl/calendar.htm -- HTH RP (remove nothere from the email address if mailing direct) "Richard Mogy" wrote in message m... 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. |
Microsoft Calendar Control
That is the control I am talking about, but others have said it doesn't
support what I want to do. Any suggestions. "Tom Ogilvy" wrote in message ... Is this the control you are talking about: http://www.fontstuff.com/access/acctut09.htm -- Regards, Tom Ogilvy "Richard Mogy" wrote in message m... 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. |
Microsoft Calendar Control
That is the control -- any suggestions as to how to do what I want to do?
"Tom Ogilvy" wrote in message ... If it is that control, it doesn't support that. -- Regards, Tom Ogilvy "Richard Mogy" wrote in message om... 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. "Bob Phillips" wrote in message ... Take a look at www.rondebruin.nl/calendar.htm -- HTH RP (remove nothere from the email address if mailing direct) "Richard Mogy" wrote in message m... 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. |
Microsoft Calendar Control
Build a userform that does what you want.
-- Regards, Tom Ogilvy "Richard Mogy" wrote in message . com... That is the control -- any suggestions as to how to do what I want to do? "Tom Ogilvy" wrote in message ... If it is that control, it doesn't support that. -- Regards, Tom Ogilvy "Richard Mogy" wrote in message om... 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. "Bob Phillips" wrote in message ... Take a look at www.rondebruin.nl/calendar.htm -- HTH RP (remove nothere from the email address if mailing direct) "Richard Mogy" wrote in message m... 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. |
| All times are GMT +1. The time now is 03:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com