Can I use this Outlook control in Excel?

  • Thread starter Thread starter Mark Driscol
  • Start date Start date
M

Mark Driscol

Outlook 2002 SP-2
Excel 2002 SP-2

There is a calendar control available in Microsoft Outlook that can be seen
via the menus File, New, Appointment, Actions, Recurrence, looking at the
"Range of Recurrence" section at the bottom of the displayed userform and
selecting the dropdown arrow of the control next to the "End by" text. I
would like to use this control in Excel rather than the Date & Time Picker
or MonthView controls.

Is this possible, and how would I accomplish it? I don't know what this
control is called or how to set a reference to it.

Thanks in advance.

Mark
 
Hi Mark,

I believe that one is called the "Microsoft Date and Time Picker" control.
You should find it in the list of additional controls (right-click the
control toolbox window and select "Additional Controls...".

--
Regards,

Jake Marx
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]
 
Thanks, Jake, but it is the Date & Time Picker and MonthViews controls I
don't want to use. They're OK, I just like this the look of this particular
control in Outlook better. Any ideas on how to be able to use it in Excel?

Thanks.

Mark


Jake Marx said:
Hi Mark,

I believe that one is called the "Microsoft Date and Time Picker" control.
You should find it in the list of additional controls (right-click the
control toolbox window and select "Additional Controls...".

--
Regards,

Jake Marx
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Mark said:
Outlook 2002 SP-2
Excel 2002 SP-2

There is a calendar control available in Microsoft Outlook that can
be seen via the menus File, New, Appointment, Actions, Recurrence,
looking at the "Range of Recurrence" section at the bottom of the
displayed userform and selecting the dropdown arrow of the control
next to the "End by" text. I would like to use this control in Excel
rather than the Date & Time Picker or MonthView controls.

Is this possible, and how would I accomplish it? I don't know what
this control is called or how to set a reference to it.

Thanks in advance.

Mark
Click to expand...
Click to expand...
 
Sorry, Mark - obviously, I can't read. <g>

I would guess MS created a custom control for this. Here's a custom control
that looks like it's pretty close in looks/functionality:

http://www.codeproject.com/miscctrl/minicalendar.asp

--
Regards,

Jake Marx
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Mark said:
Thanks, Jake, but it is the Date & Time Picker and MonthViews
controls I don't want to use. They're OK, I just like this the look
of this particular control in Outlook better. Any ideas on how to be
able to use it in Excel?

Thanks.

Mark


Jake Marx said:
Hi Mark,

I believe that one is called the "Microsoft Date and Time Picker"
control. You should find it in the list of additional controls
(right-click the control toolbox window and select "Additional
Controls...".

--
Regards,

Jake Marx
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Mark said:
Outlook 2002 SP-2
Excel 2002 SP-2

There is a calendar control available in Microsoft Outlook that can
be seen via the menus File, New, Appointment, Actions, Recurrence,
looking at the "Range of Recurrence" section at the bottom of the
displayed userform and selecting the dropdown arrow of the control
next to the "End by" text. I would like to use this control in
Excel rather than the Date & Time Picker or MonthView controls.

Is this possible, and how would I accomplish it? I don't know what
this control is called or how to set a reference to it.

Thanks in advance.

Mark
Click to expand...
Click to expand...
Click to expand...
 
Thanks, Jake, that does look pretty close!

Mark


Jake Marx said:
Sorry, Mark - obviously, I can't read. <g>

I would guess MS created a custom control for this. Here's a custom control
that looks like it's pretty close in looks/functionality:

http://www.codeproject.com/miscctrl/minicalendar.asp

--
Regards,

Jake Marx
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Mark said:
Thanks, Jake, but it is the Date & Time Picker and MonthViews
controls I don't want to use. They're OK, I just like this the look
of this particular control in Outlook better. Any ideas on how to be
able to use it in Excel?

Thanks.

Mark


Jake Marx said:
Hi Mark,

I believe that one is called the "Microsoft Date and Time Picker"
control. You should find it in the list of additional controls
(right-click the control toolbox window and select "Additional
Controls...".

--
Regards,

Jake Marx
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Mark Driscol wrote:
Outlook 2002 SP-2
Excel 2002 SP-2

There is a calendar control available in Microsoft Outlook that can
be seen via the menus File, New, Appointment, Actions, Recurrence,
looking at the "Range of Recurrence" section at the bottom of the
displayed userform and selecting the dropdown arrow of the control
next to the "End by" text. I would like to use this control in
Excel rather than the Date & Time Picker or MonthView controls.

Is this possible, and how would I accomplish it? I don't know what
this control is called or how to set a reference to it.

Thanks in advance.

Mark
Click to expand...
Click to expand...
Click to expand...
 
Back
Top