ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Control for selecting dates and times (https://www.excelbanter.com/excel-programming/433098-control-selecting-dates-times.html)

Michelle

Control for selecting dates and times
 
Hello, are there calendar/clock controls for selecting dates and times in a
user form?

I know there's a calendar if you have access installed, but is that the only
one?

If there are, what are the limitations of them?

Thanks

M


Patrick Molloy[_2_]

Control for selecting dates and times
 
yes, look for the Date Time Picker control

"Michelle" wrote:

Hello, are there calendar/clock controls for selecting dates and times in a
user form?

I know there's a calendar if you have access installed, but is that the only
one?

If there are, what are the limitations of them?

Thanks

M



Rick Rothstein

Control for selecting dates and times
 
I *think* that is only available if the compiler version of VB is installed
or if a 3rd party application that used it is installed on the user
computer... I don't think (not positive though that) it is natively
installed with windows.

--
Rick (MVP - Excel)


"Patrick Molloy" wrote in message
...
yes, look for the Date Time Picker control

"Michelle" wrote:

Hello, are there calendar/clock controls for selecting dates and times in
a
user form?

I know there's a calendar if you have access installed, but is that the
only
one?

If there are, what are the limitations of them?

Thanks

M




Michelle

Control for selecting dates and times
 
The date time picker is lovely and does exactly what I want, but if it's not
installed with windows, does that mean the control won't work on machines
that don't have it - If that's so, is there some way to 'embed' it into my
ptoject so that it will always work?

Thanks

M

"Rick Rothstein" wrote in message
...
I *think* that is only available if the compiler version of VB is installed
or if a 3rd party application that used it is installed on the user
computer... I don't think (not positive though that) it is natively
installed with windows.

--
Rick (MVP - Excel)


"Patrick Molloy" wrote in
message ...
yes, look for the Date Time Picker control

"Michelle" wrote:

Hello, are there calendar/clock controls for selecting dates and times
in a
user form?

I know there's a calendar if you have access installed, but is that the
only
one?

If there are, what are the limitations of them?

Thanks

M





Rick Rothstein

Control for selecting dates and times
 
I'm not 100% sure that it is not installed with windows (hopefully someone
who knows for sure will come along and confirm or refute my recollection),
but if it isn't, then I'm pretty sure you can't embed it into your project.
If you were using the compiler version of VB you could, though, but then
that would kind of change your approach to your whole project I would guess.

--
Rick (MVP - Excel)


"Michelle" wrote in message
...
The date time picker is lovely and does exactly what I want, but if it's
not installed with windows, does that mean the control won't work on
machines that don't have it - If that's so, is there some way to 'embed'
it into my ptoject so that it will always work?

Thanks

M

"Rick Rothstein" wrote in message
...
I *think* that is only available if the compiler version of VB is
installed or if a 3rd party application that used it is installed on the
user computer... I don't think (not positive though that) it is natively
installed with windows.

--
Rick (MVP - Excel)


"Patrick Molloy" wrote in
message ...
yes, look for the Date Time Picker control

"Michelle" wrote:

Hello, are there calendar/clock controls for selecting dates and times
in a
user form?

I know there's a calendar if you have access installed, but is that the
only
one?

If there are, what are the limitations of them?

Thanks

M







All times are GMT +1. The time now is 06:01 PM.

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