What are some effecient ways to allow users to enter date
in the format of "mm/dd/yy" or "mm dd yy" on a text box
or form control?

I guess what concerns me the most are typo issues, or
circumstances when users enter typos or dates in the wrong
format.

Hi Robert,

Am Wed, 14 Oct 2015 12:11:12 -0700 schrieb Robert Crandal:

What are some effecient ways to allow users to enter date
in the format of "mm/dd/yy" or "mm dd yy" on a text box
or form control?

I guess what concerns me the most are typo issues, or
circumstances when users enter typos or dates in the wrong
format.

a text box contains text. You have to check for typos and you have to
convert the text to a date if you want to calculate it.
I would prefer a Date and Time Picker or Calendar Control.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

"Claus Busch" wrote:

I would prefer a Date and Time Picker or Calendar Control.


My system has no calendars or DTP controls. Downloading them
is not an option either.

Suppose you cannot use any of the above options. What solutions
come to mind?

Hi Robert,

Am Thu, 15 Oct 2015 03:27:52 -0700 schrieb Robert Crandal:

Suppose you cannot use any of the above options. What solutions
come to mind?

please look again in the Office folder for OfficeXX\MSCAL.OCX
where XX is the version number.
If the users cannot write the date into the sheet use a text box and
write the value to the sheet with e.g.
Range("A1")=CDate(TextBox1.value)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

"Claus Busch" wrote:

please look again in the Office folder for OfficeXX\MSCAL.OCX
where XX is the version number.


Okay, I will check later today if I can find "mscal.ocx" on our computer.

I don't understand why the calendar control isn't automatically available
in the Control toolbox. Even when I check "Additional Controls", it's
nowhere
to be found.

If I do find "mscal.ocx" in my file system, how do I install that into Excel
2013?


If the users cannot write the date into the sheet use a text box and
write the value to the sheet with e.g.
Range("A1")=CDate(TextBox1.value)


The user will be presented with a UserForm that contains textboxes
and other controls (or a Calendar control if I can find and install it).
Once a valid date is entered onto the form, I plan to save that date
value in a variable. The date will not be outputted onto the sheet at all.

Hi Robert,

Am Thu, 15 Oct 2015 05:14:40 -0700 schrieb Robert Crandal:

If I do find "mscal.ocx" in my file system, how do I install that into Excel
2013?

if you have it on the PC you can register it with Windiows Button + R
"D:\Programe Files (x86)\Microsoft Office\Office12\MSCAL.OCX /regserver"

You have to modify your path for your system

The user will be presented with a UserForm that contains textboxes
and other controls (or a Calendar control if I can find and install it).
Once a valid date is entered onto the form, I plan to save that date
value in a variable. The date will not be outputted onto the sheet at all.

A public variable is only available as long as you run the application.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Hi Robert,

Am Thu, 15 Oct 2015 05:14:40 -0700 schrieb Robert Crandal:

Okay, I will check later today if I can find "mscal.ocx" on our computer.

please have a look:
https://msdn.microsoft.com/en-us/lib...4-5e729cae4d70
https://community.spiceworks.com/how...ft-access-2010
https://social.technet.microsoft.com...eitproprevious
https://social.msdn.microsoft.com/Fo...forum=exceldev
http://www.fontstuff.com/mailbag/qvba01.htm


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

hi,

Le 2015-10-15 08:14, Robert Crandal a écrit :
If I do find "mscal.ocx" in my file system, how do I install that into Excel
2013?

win7 32 bits or 64 bits ?

isabelle