![]() |
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. |
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 |
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? |
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 |
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. |
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 |
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 |
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 |
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 |
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. |
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 |
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? |
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