I usually share my works with mates and they werent able to proceed whenever they have been encountered with DTPicker missing library problems.There are instruction documents, but they rely on a control that doesnt exist.In either way, you will need to implement the actions when you click on these controls.
When I navigate to the file, an error message indicates Cannot Register this control. Now what. You need to register it and can then easily use the date picker. Im getting frustrated with something that should be very simple. I am using fusion on a mac, but I cant imagine that being the issue. I dont see a calendar date picker among the activeX controls. Assuming that you know what it is called, I will still need help setting this up. Sigh. Microsoft Date And Time Picker Control 6.0 Sp6 Code That WillI developed code that will create a dateGetter userform, get the users date selection as a Global variable, and then delete the form. It should be compatible with most systems, though I havent tested it on others than my own. Dim myForm As Object, calendarForm As Object, newLabel As MSForms.Label, newSpinner As MSForms.SpinButton. Dim NewButton As MSForms.CommandButton, newButton2 As MSForms.CommandButton. Function dhDaysInMonth(Optional dtmDate As Date 0) As Integer. Im surprised it isnt rated higher but I guess no one realized what youre doing. Chip has a wonderful section on holidays and other work week functions. Though I used some of his code here (and gave him credit), most of this code is my code geared toward portability of a hand made date picker. At my work there are some stations that dont have all the references that my station has and the common EXCEL date picker will just not work if a station doesnt have that GUID on it. Then you can use the form as any other type form with.show command. Its sad but it feels like corporate America is moving away from VBA which I love. Im now getting heavy push to use R which really isnt any better and doesnt have nearly as robust error handling. Which is why I built this on-the-fly calendar userform that is universal. Either different versions or some have the necessary references and others dont. And my ability as a programmer too.) So thats why MS is leaning away from it I guess. Microsoft Date And Time Picker Control 6.0 Sp6 How To Get ItTheir error system should alert the user that a reference is missing and how to get it or make references portable in a separate module.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |