MonthView | android library to display month calendar | Calendar library

Problem Statement

In VBA, three main kinds of date time controls can be used provided certain ocxs have been registered using administrator rights. These are VB6 controls and are not native to VBA environment. To install the Montview Control and Datetime Picker, we need to set a reference to Microsoft MonthView Control 6.0 (SP4) which can only be accessed by elevated registration of mscomct2.ocx. Similarly for mscal.ocx and mscomctl.ocx. Having said that, the deprecated mscal.ocx may or may not work on Windows 10.

Depending on your Windows and Office versions (32 bit or 64 bit), it can be really painful to register these ocxs.

The Monthview Control, Datetime Picker and the deprecated Calendar control look like below.

So what problem can I face if I include these in my applicaiton?

If you include them in your project and distribute them to your friends, neighbours, clients etc the application may or may not work depending on whether they have those ocx installed.

And hence it is highly advisable NOT to use them in your project

What alternative(s) do I have?

This calendar, using Userform and Worksheet, was suggested earlier and is incredibly basic.

When I saw the Windows 10 calendar which popped up when I clicked on the date and time from the system tray, I could not help but wonder if we can replicate that in VBA.

This post is about how to create a calendar widget which is not dependant on any ocx or 32bit/64bit and can be freely distributed with your project.

This is what the calendar looks like in Windows 10:

and this is how you interact with it:

I have just started using the Kendo MVC Schedule component. I can get the schedule to display with data contained in the schedule. But, what I'm having a hard time determining is how to get the information associated with the item selected when the user clicks on an item in the schedule. For example, I'd like to be able to retrieve the title and description fields from my model that I passed to the Schedule object.

I do have the following JS function that is being fired when the user clicks on an object:

I have a UserForm of a MonthView that opens when I click in the specified range of cells. This SO thread gave me the basic script. It doesn't put the UserForm where I expect.

Here is the script (that I placed in a specific worksheet) to open the UserForm when I click any cell in range B3:C2000.

Problem: i tried to make this example https://swiftui-lab.com/communicating-with-the-view-tree-part-1/ a bit swiftier by not using the same MonthView() 12 times but in a loop. Unfortunately when tapping the label/month the variable activeIdx won't be updated and I have no idea why... and my question is: how do i have to change the code that the binding works? Expected behaviour: When you tap on the month names the red border should mark the label you tapped.

I'm setting the value of a Kendo Text Box For in Javascript, having that value displayed on the screen, but getting an error that the field is null and the model state invalid when it gets to the controller. How do I set the value of the text box and retain that value so the model state is valid?

Here's what I have:

• ASP.net MVC Visual Studio project with C#
• Kendo/Telerik Scheduler Control
• Event pop-up of the Scheduler defined in template (separate CSHTML file)
• In the template, a Kendo TextBoxForControl for the field Title
• Also in the template, a Kendo drop down list for the field TaskSourceWoId

When a user selects a value from the dropdown, Javascript sets the value of the Title like this:

I'm new to using the AlloyUI Scheduler. I have found how to display an alert if a item is saved, edited or deleted but I can't seem to find out how to show an alert if the item is moved, ie moved to another time or day. I would have thought that the 'edit' event would have handled this but apparently not. This is the code I have.

I have a grid here which shows all the projects from the Db that have their statuses as "Open". Now I want to show a different colour for each project on the scheduler. Currently, it's showing the projects with the same colour, which can confuse users. Please see the images below of the screen and the code.

I am using JqxScheduler for schedule appointments.
It seems if we select a cell using left click and right click on different cell jqxScheduler not select that cell where we are right-clicked.
My requirement is reset all cell if the user right clicks on other cell and select that right-clicked. Have added one solution but it works only once at first time.

I have "Microsoft MonthView Control 6.0 (SP4)" component that enters the date to cell "D17" I want my function to compare today date to cells "D17" date and give certain message. So if date in cell "D17" is older than current date it will display "OFFER EXPIRED" message. In cell "D17" I currently have 1.10.2018. I use formula =IF(D17>TODAY();"OFFER EXPIRED";"") but it doesn't work. I have tried different cell Formatting options with no success. Any ideas where the problem can hide?