Can I use this Outlook control in Excel?

[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

 

[Jake Marx]

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]

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

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]

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

 

[Jake Marx]

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]

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

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]

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

 

[Mark Driscol]

Thanks, Jake, that does look pretty close!

Mark

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]

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

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