Calendar Control v1.2.0 - with Office 2016 compatibility. In a recent Microsoft Windows security patch, the button transparency settings are rendered ineffective. This is the same story as the Mac version you see in v1.0.2.
- J
Export Date from text box in userform to dtpicker in sheet
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...- Thread
- date dtpicker dtpicker1.value monthview userform userform calendar textbox vba
- Replies: 0
- Forum: Excel Questions
- C
Return Year only from MonthView Calendar
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...- Thread
- .cellsicnt calendar code monthview year
- Replies: 1
- Forum: Excel Questions
- D
How to update MonthView for current year
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...- Thread
- calendar date picker monthview
- Replies: 1
- Forum: Excel Questions
- V
Can't find MonthView Control
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...- Thread
- addin monthview
- Replies: 2
- Forum: Excel Questions
- C
UserForm MonthView default = blank empty
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- Thread
- macro monthview userform vba
- Replies: 0
- Forum: Excel Questions
- E
Make code affect column X and Z, but not Y
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...- Thread
- monthview
- Replies: 3
- Forum: Excel Questions
- D
Monthview show/hide
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...- Thread
- hide monthview popup show vba
- Replies: 2
- Forum: Excel Questions
- D
VBA MonthView Multiselect Start and End Date Into Cells
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...- Thread
- excel-2013 monthview vba
- Replies: 0
- Forum: Excel Questions
- D
Custom Date & Time Range Userform
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...- Thread
- dtpicker excel-vba monthview userform
- Replies: 0
- Forum: Excel Questions
- J
Monthview control Disappearing...Repeatedly
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...- Thread
- monthview vba
- Replies: 0
- Forum: Excel Questions
- M
Custom DatePicker and Monthview no installations no add ins
ProblemDate 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...- Thread
- add in datepicker end user monthview unavailable
- Replies: 3
- Forum: Excel Questions
- N
Populate Two TextBox using a Single Pop-up Calendar
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...- Thread
- monthview pass by value textbox
- Replies: 1
- Forum: Excel Questions
- L
Upgraded to 2013 and now having weird issues
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...- Thread
- 2013 date format excel monthview upgrade
- Replies: 1
- Forum: Excel Questions
- H
Using MonthView ActiveX control, doesn't open to today's date
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?- Thread
- activex monthview
- Replies: 1
- Forum: Excel Questions
If you've attended one of our Excel VBA training courses you might remember using the Date and Time Picker control when building a user form.
An exciting shot of the Date and Time Picker in action. As its name suggests, it allows a user to pick a date and time value rather than having to type it in.
Disclaimer 2 - This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). I am building a form and need the Microsoft MonthView Control 6 (SP4) option to insert a calendar for choosing a date. I don't see this option in the Additional Controls box of the Toolbox. I am working with Excel 2016. I appreciate any help anyone in the community can lend. Hi experts, i m new to vba, i would like to insert a date picker calendar in my VBA Form. But Microsoft MonthView Control is missing in excel form controls. Using 64 bit windows 10, excel 2016. I came to know that mscomct2.ocx is will not run in 64 bit win10. But after registering mscomct2 DOS msg.
The Date and Time Picker is immensely useful when designing VBA user forms but, sadly, it isn't included with every version of Windows. I discovered this recently when moving to a new machine with a 64bit edition of Windows 7 installed. Fortunately, it is relatively simple to install the Date and Time Picker, as long as you don't mind getting your hands dirty with a couple of simple command line instructions.
Downloading the Files You'll Need
The Date and Time Picker is part of a library of tools with the catchy title of MSCOMCT2.OCX. To start with, you'll need to download this file from the Microsoft support site.
Click this link on the page to start downloading the file.
UPDATE: Sadly, Microsoft have since removed this file from their site. You can still download it from a variety of third-party sites which you can find with a brief bit of Googling.
When you've clicked the link to start downloading the file, choose to save it somewhere on your computer.
Click the Save as option so that you can choose where to save the file.
On the next dialog box choose a location on your computer and then click Save to download the file.
Extracting the Downloaded File
Once it's finished downloading you'll need to extract the file. Start by double-clicking on the file that you've downloaded.
Double-click the .cab file to see what it contains.
Once inside the .cab file you can choose to extract the .ocx file by right-clicking on it and choosing Extract...
Right-click the file called mscomct2.ocx and choose to extract it.
Choose which folder you want to extract the file to and click Extract.
Select an existing folder, or create a new one, and then click Extract.
Copying the File to the Correct Folder
In order to make use of the file you've downloaded you'll need to place it in the correct folder for the edition of Windows that you're using. Start by opening a Windows Explorer window and browsing to the Windows installation folder. On my machine this is C:Windows.
The next folder you need to browse to depends on which edition of Windows you're using. If you're using a 32bit edition you'll need the System32 folder. If you're using a 64bit edition, like I am, you'll need SysWOW64.
Once you've navigated to the correct folder, simply move or copy the MSCOMCT2.OCX file into it.
The file now sits in the correct folder.
Registering the File
Before you can make use of the file you'll need to register it. You can do this using the command line tool in Windows. Go to the Start menu and in the search box type cmd.
Type cmd into the search box at the bottom of the Start menu.
Still in the Start menu, right-click on the cmd.exe item which appears and choose to run it as an adminstrator.
Right-click on the icon and choose Run as administrator.
At the command prompt make sure that the directory shown is the same as the one you copied the file into earlier.
If I was running a 32bit edition of Windows 7 this would be pointing to the correct folder.
If you need to change the directory you can do so using a command similar to the one shown below. Of course, you'll need to use the directory relevant to your own Windows installation.
Press Enter at the end of the line to change the directory.
Once you've changed the directory you can write one final command to register the file on your machine.
For reference, the command is regsvr32 mscomct2.ocx
If everything works normally you should see a message similar to the one shown below:
Using the Date and Time Picker
You should now find that you can use the Date and Time Picker control in your VBA forms.
In the design view of a VBA form, right-click on the Toolbox and choose Additional Controls...
On the dialog box which appears, check the box next to the entry for the Microsoft Date and Time Picker Control 6.0.
Microsoft Monthview Control 6 0 Excel 2016 Download 64-bit
You'll find that you have access to several other controls from the mscomct2.ocx library as well.