Hi guys and girls,
I have a Workbook with userform where I use Microsoft Date / Time picker control.
However, not all machines where this workbook is used have the OCX (MSCOMCT2.ocx) that allows this control installed.
(source: here)
Is there any way to 'embed' the control with the workbook, so it will work regardless of the OCX being available on the machine?
Since I suspect the answer to this to be no - is there any good alternative available, apart from a standard textbox?
Thanks,
Jasper
As far as I know the answer is NO
You have to use form added in that workbook and use VBA Change/Selection event to get the date picker
http://www.rondebruin.nl/win/s8/win003.htm
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks, I went over Ron's site and saw a couple of alternatives that are not depending on any dll or ocx to be registered.
However, to have 100+ lines of additional code just to have a nice looking date picker seems a bit much to me.
Damn you Microsoft!
If noone else has any decent alternatives, then I'll just go with a textbox input...
Just transfer (Export) the DatePicker Forms and Modules to your workbook and use it in your workbook.
Check this attached file.
You can just export the form and Modules to your desired excel workbook and use double click event to pop up the Date Picker
It's still a bit of a pain to remove all redundant stuff from it, but I guess I did that.
Now, can I capture when someone clicks a textbox on a userform?
Basically I want when the user clicks/activates the textbox next to "start date" to pop up the form.
Never mind, found it - Thanks Sixthsense for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks