monthview

has anybody used this for selecting dates on a userform? if so how do you programme it? I have tried serveral different ways to input a date but when it is text if fails when entering for October

I’ve been using monthview control on a user form for many years even though it is no longer included in Excel 365. I’ve had to re-register mscomct2.ocx many times but always was successful in getting the control to function until last week. I had a problem and had to reinstall Office 365 and...

Hello everyone! I am trying to develop a MonthView control as Excel 365 64-bit down not support the mscomct2.ocx I have looked around and put together ideas, such as the strategy to capture a label click I found in the thread below Userform Label Click problem However, now I am stuck as all I...

Hello! i'm having trouble linking a Date box from a userform to a dtpicker in sheet (because i need the dtpicker with calendar available if the date is to be altered). I have tried this code, but obviously it didn't work...DATE1 is the box in the userform and DTPicker1 (from the development...

How do i return the year only in a cell from a monthview calendar in a userform. Currently using the current code, where icnt refers to the last row in the sheet plus 1 and the values are yielded from a userform " With Sheets("Register") .Cells(iCNT, 1) = Calendar.Value...

I made an attendance register (using Excel 2013) for my classroom about 2 years ago. It uses MonthView to select dates from a form for new student admissions. My problem NOW, is that the Monthview is still stuck in 2014 every time the form pops open. How can I change the MonthView so it reflect...

Hii, I have use Monthview control in my form and created a addin.. but when i distributed the addin.. it gave me error project/library not loaded.. so i got missing file in Refrecens.. i installed it in the other system now it doesn't show that the reference is missing.. but i still can't find...

Hello I want to use the Month View Calendar in my UserForm but I want to Change the Default to blank. So if someone uses my UserForm for a new entry and does not select a date, there also will be no entry in my sheet. In the Moment it automatically inserts todays date

I understand that I lack some basic knowledge on VBA... Hopefully I will learn these basics as I use it more.... I have implemented a MonthView control on my worksheet. When I click a cell in column F, the calendar pop up. I want the same to happen for column D. I tried to change the...

Hi all, Had a search for this but couldn't find anything.... hopefully someone can help! Basically I'm designing a user form and want the date picker to 'pop up' / appear when the user clicks in the text box and disappear when they click out of it. The input to the calendar currently populates...

Hi Everyone, So I have a MonthView userform set up with the multiselect option enabled. I'm trying to get the start date and end date that the users select into two different cells on the worksheet (let's say A1 and B1 for example). From what I've looked up I understand that you can get the...

Hi Everyone, I'm trying to put together a userform where the user selects a date range, inputs a start time and an end time, and then hits a button to input those values combined into two cells. Here's what the userform looks like: I have it set so that the user can drag to select the range...

Hello all, So I've only seen this happen once before today and I thought it was something else but today I tried to use a userform where I had previously placed a monthview control, and it failed to run because the monthview control was no longer on the form.. I checked my toolbox and the...

Problem Date and Time Picker & Monthview controls are not included as a standard since Excel 2010 (additionally there are some known issues). So the additional controls are buggy (>download< - >step by step<): Microsoft Date and Time Picker Control 6.0 (SP6) Microsoft MonthView Control 6.0...

Hi! Newbie here! I think this question has been posted several times and I have looked into different boards and threads but can't get my form to work properly. Basically, I have a user form with two textbox and a command button for each. The command button will call the calendar form, where...

Hello, I was just recently upgraded from Office 2010 to 2013. I had several macros in 2010 that I used regularly that are no longer working. One of the reasons has been resolved -> it was having issues with date formats or recognizing dates even when manually typing them in. This was fixed...

Hi, I'm using the ActiveX control Monthview (where a calendar pop up when you click a specific cell). But every time I open it, it display the month I create the object, not the month that the current date is. Is there some code I can add to make sure the calendar opens to the current month?