ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Date picker on a form? (https://www.excelbanter.com/excel-programming/451145-date-picker-form.html)

Robert Crandal[_3_]

Date picker on a form?
 
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.



Claus Busch

Date picker on a form?
 
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

Robert Crandal[_3_]

Date picker on a form?
 
"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?




Claus Busch

Date picker on a form?
 
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

Robert Crandal[_3_]

Date picker on a form?
 
"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.



Claus Busch

Date picker on a form?
 
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

Claus Busch

Date picker on a form?
 
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

isabelle

Date picker on a form?
 
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

isabelle

Date picker on a form?
 
hi,

http://answers.microsoft.com/en-us/o...a2a315a?page=2

Trevor Eyre's date picker which can be downloaded from http://bit.ly/1ossyMA

isabelle

Le 2015-10-16 20:20, isabelle a écrit :
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


Robert Crandal[_3_]

Date picker on a form?
 
"Claus Busch" wrote:

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"


I won't be able to tamper with the system environment in any way. Downloads
are also out of the question.

Looks like I will need to create this on my own from scratch using what's
available in the default toolbox. It shouldn't be too hard.

Thanks for your help Claus and Isabelle.




Claus Busch

Date picker on a form?
 
Hi Robert,

Am Sun, 18 Oct 2015 01:07:04 -0700 schrieb Robert Crandal:

Looks like I will need to create this on my own from scratch using what's
available in the default toolbox. It shouldn't be too hard.


you can also use 3 comboboxes for year, month and day.
Please have a look:
https://onedrive.live.com/redir?resi...=folder%2cxlsm
for "DateSerial"


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

Robert Crandal[_3_]

Date picker on a form?
 
"Claus Busch" wrote:

you can also use 3 comboboxes for year, month and day.
Please have a look:
https://onedrive.live.com/redir?resi...=folder%2cxlsm
for "DateSerial"


Thanks Claus. I had similar ideas, but that helps a lot too.

BTW, did you create all those examples yourself on that site?




Claus Busch

Date picker on a form?
 
Hi Robert,

Am Mon, 19 Oct 2015 09:49:02 -0700 schrieb Robert Crandal:

BTW, did you create all those examples yourself on that site?


all the workbooks are examples for asked questions in the newsgroups.


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


All times are GMT +1. The time now is 08:24 PM.

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