ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Interfacing OL2002 Cal and Excel Userforms (https://www.excelbanter.com/excel-programming/275907-interfacing-ol2002-cal-excel-userforms.html)

Bruccce

Interfacing OL2002 Cal and Excel Userforms
 
I need to schedule 5 min appointments (and make sure that the time is avail,
if not, what is the next free time after that) for a call back to a contact,
and then have excel remind me about this appoint with a msgbox (if excel is
running! and the given worksheet is open) and if I press OK (or "CallNext")
on the msgbox, to have that cust scheduled as the next contact.
I am using userforms most of the time, if that makes any difference.



Thanks
Bruce





Dick Kusleika[_2_]

Interfacing OL2002 Cal and Excel Userforms
 
Bruce

Here's a place to start

http://www.dicks-clicks.com/excel/olCalendar.htm

Since Outlook has such a nice reminder feature, I don't know why you would
want a reminder in Excel.

We'll need more details on where your contacts are stored, what kind of code
you have behind your userform, and stuff like that for more detailed
answers.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com


"Bruccce" wrote in message
.net...
I need to schedule 5 min appointments (and make sure that the time is

avail,
if not, what is the next free time after that) for a call back to a

contact,
and then have excel remind me about this appoint with a msgbox (if excel

is
running! and the given worksheet is open) and if I press OK (or

"CallNext")
on the msgbox, to have that cust scheduled as the next contact.
I am using userforms most of the time, if that makes any difference.



Thanks
Bruce








All times are GMT +1. The time now is 05:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com