ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   DTPicker Bug (https://www.excelbanter.com/excel-programming/392069-dtpicker-bug.html)

Steve23

DTPicker Bug
 
My platform is Win XP Pro and Office 2007 Pro. Have located a bug when using
DTPicker - does anybody out there know a workaround or how to notify MS
officially? I use VBA to build forms and manipulate data in Excel. I have
added three DTpicker controls so user can select date (from calendar), start
time and end time (both with up/down option). These controls are on page 1
of a 2-page MultiPage. Page 1 is used to gather client information, page 2
for client notes. As soon as the user moves to page 2, the values entered in
these 3 controls on page 1 are lost (i.e. revert to system date/time)! Very
annoying. Furthermore, I prefer a custom format for the start/end times
(i.e. HH:mm not the default hh:mm:ss AM/PM). When you switch back from page
2 to page 1, the start/end times revert to displaying date not time. Grrrr.
Can anyone help?
--
Steve


All times are GMT +1. The time now is 11:17 AM.

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