Sachin Agrawal
New Member
Hi All,
Are you a VBA Developer using Windows Date-Time Picker control in your projects then you knows how problematic using this control is.
By googling I found a VBA alternative of this control. A calendar, build with VBA code. I made some changes to it and designed it to work just like Windows Date-Time Picker control.
Sharing it here for all VBA programmers (With Code). Download sample workbook At : www.excelapps.webs.com/downloads
But still one problem is there. I coded to display calendar at the bottom of cells formatted as date. It works good when excel window is not scrolled down. But when it is scrolled down, calendar position do not changes relevant to active window frame. For example if I format cell C50 as date then on clicking it calender do not display at the bottom of C50. It actually disappears from the active frame. Can any one suggest the code to change the calendar position relevant to scrolled window.
Thanks in Advance
Are you a VBA Developer using Windows Date-Time Picker control in your projects then you knows how problematic using this control is.
By googling I found a VBA alternative of this control. A calendar, build with VBA code. I made some changes to it and designed it to work just like Windows Date-Time Picker control.
Sharing it here for all VBA programmers (With Code). Download sample workbook At : www.excelapps.webs.com/downloads
But still one problem is there. I coded to display calendar at the bottom of cells formatted as date. It works good when excel window is not scrolled down. But when it is scrolled down, calendar position do not changes relevant to active window frame. For example if I format cell C50 as date then on clicking it calender do not display at the bottom of C50. It actually disappears from the active frame. Can any one suggest the code to change the calendar position relevant to scrolled window.
Thanks in Advance
Last edited by a moderator:
