- V
Ron DeBruin add in - date picker for online version
Hi, I installed Ron DeBruin's add in . It worked in excel but after uploading the file to the SharePoint, the option is not available. So is it only for regular excel?Thanks,VJ- Thread
- datepicker
- Replies: 3
- Forum: Excel Questions
Closeup datepicker with VBA code
I have this datepicker that I have placed on a frame in order to hide it and show it in various instances. Now I am using the 'mouseMove ' event from a parent frame to hide or show the datepicker.It responded fine. The only issue here is that when the datepicker is opened, after hiding the..- Thread
- datepicker frame hide show solutions
- Replies: 2
- Forum: Excel Questions
- J
Populate a cell with a date using DatePicker
When I select a cell to add a date using DatePicker drop down box, I select a date but nothing displays in the selected cell. The code I used is;Private Sub Worksheet_SelectionChange(ByVal Target As Range) With Sheet1.DTPicker1 .Height = 20 .Width = 20 If Not Intersect(Target..- Thread
- .visible cell date datepicker end
- Replies: 4
- Forum: Excel Questions
- R
Use Date Picker to Locate and Select a Cell
Is there a way to code a DatePicker so that when you choose a date it will look in column A and select the cell that date it in? so if i choose 11/1/2019 in the date picker it will look through column A, find the date, and select the cell.- Thread
- cell choose date datepicker select
- Replies: 2
- Forum: Excel Questions
- H
DatePicker 32 & 64-bit
I've found a datepickerhttps://www.dropbox.com/s/at2peyyhttnbvnw/New%20Calendar%20Ver%204.xlsm?dl=0I tried to find the way to use the ' DTINSERT'-knob to use the date in another ProcedureThere is a timer event which gets activated in the launch code.When you stop the code midway, the timer..- Thread
- code datepicker event stop timer
- Replies: 0
- Forum: Excel Questions
- C
Datepicker, Default to previous workday
OK I have this in my code which defaults the datepicker to todays date but I have tried to no avail to get it to use previous workday as defasult date.I know this is gonna be simple but here is what I have now which works for today.PrevRptDate.PrevDTPicker.Value = DateI have tried a few..- Thread
- date datepicker default previous workday
- Replies: 3
- Forum: Excel Questions
- R
using a macro to change the date of a Datepicker
I have a worksheet that when a user completes they click on a button and the data is copied, pasted, and all the fields reset to blank except the DatePickeris there something I can do to call the DatePicker to reset itself back to 1/1/2019?I've been looking all over and I have found examples..- Thread
- 1/1/2019 back call datepicker reset
- Replies: 4
- Forum: Excel Questions
- A
DatePicker
HiI'm trying to put a DatePicker in my sheet in Column A.I've used the tutorial below to do that.https://github.com/Amallard/excelTricks/blob/master/DatePickerToCells.mdHowever, I need the datepicker range to start in column A from Cell 2 so that it doesn't mess up the table header.Here..- Thread
- column datepicker sheet thing vba
- Replies: 5
- Forum: Excel Questions
Excel Datepicker to show by default NA value
Hello, Is there a way to make a Default Value N/A for Datepicker. So, user will know that there is no date selected for a particular.Thank you in advance.- Thread
- date datepicker default excel selected
- Replies: 1
- Forum: Excel Questions
- G
Datepicker in a listbox/listview second column
HiIs possible to have a datepicker (or maybe just another control like button etc) in a listox or listvew control for every item? And if yes, how is that done.Thanks for any hit/help.- Thread
- control datepicker hit/help item listvew
- Replies: 9
- Forum: Excel Questions
- K
Distinction if VBA or user enter textbox
Hi,I have 4 textboxes in a userform1. When I click in one of them textbox1_enter, I have a separate datepicker userform2 that shows and puts its value in the textbox. It took time but that works.My issue is that when I initialize userform1, I would like to have specific dates in the..- Thread
- datepicker effect textbox textboxes userform1
- Replies: 4
- Forum: Excel Questions
- P
datepicker and monthview control question
As the title states, I have a datepicker and monthview control question. Since I didn't have these controls originally under the Additional Controls selection. I found out how to install the .ocx file that will allow these controls to be added to the Additional Controls selection. So my question..- Thread
- additional controls datepicker question selection
- Replies: 3
- Forum: Excel Questions
- K
need help with copying date from userform and changing the format of it before its copied to sheet
I have a macro that runs when the workbook is opened and looks at the date column and takes the date, copies it and pastes it as text in a hidden column so that it reads 'Apr-2018' (or whatever the month/year is in the date.)But I cannot get the same function to work when attempting to do it a..- Thread
- column copy date datepicker spreadsheet
- Replies: 4
- Forum: Excel Questions
- M
Passing Userform Vairiable to Main Module
Right now, my macro starts Module1 [Sub simpleXlsMerger()], which opens a userform that collects start and end dates using 2 datepicker controls. The dates are collected in another sub procedure [Private Sub CmdOK_Click()]. How do I pass these dates back to Module1? Ive read that I need to..- Thread
- datepicker dates module1 passing dates vba
- Replies: 10
- Forum: Excel Questions
- D
MSCOMCT2.ocx download
Hi does anyone know where this file can be found anymore, it does not seem to be supported anywhere, I am trying to find a userform datepicker.Is there another way to get one?- Thread
- datepicker download file find userform
- Replies: 6
- Forum: Excel Questions
- B
DatePicker Control to default to first day of year current year
Hi,I have a datepicker control in my userform that currently defaults to today's date using the code below. Do you know how to modify this to always show the first day of the current year?Me.DTPicker1.Value = DateThanks- Thread
- control current date datepicker year
- Replies: 7
- Forum: Excel Questions
- M
DatePicker Problems
I am having trouble with Excel 2010 addin Microsoft Datepicker. Much has been written but cannot find my answers. It looks like it is impossible to feed it a null date. I would like it to start blank.2nd Question. I have 2 datepickers on one sheet. I would like one of them locked so it is..- Thread
- datepickerdatepickers effect locked sheet
- Replies: 0
- Forum: Excel Questions
- E
Vlookup with combox and Datepicker VBA
I need to borrow someone brain for some help please.ScenarioI have Combox3 which value set via Rowsource on the property tab -It works! I am using a Datepicker to store data underneath the datepickers date starting in Row 4 going down for the day -it wont exceed 400 rows going down) So I..- Thread
- combobox3.value datepicker day msgbox set
- Replies: 1
- Forum: Excel Questions
- X
DatePicker calendar to cells
I have been trying to add a calendar to a cell to help with data entry. I have followed along with this youtube video on how to add a Date Picker and the steps worked except the outcome doesn't work for me. https://www.youtube.com/watch?v=kYNaiXmbcoAI am able to get the button to appear on..- Thread
- calendar cell date datepicker shows
- Replies: 7
- Forum: Excel Questions
- S
DatePicker in Excel 2013 x64
How can I get DatePicker to work (or any other calendar function). I currently have a sheet with it on excel 2003 with only x32 (work PC). When I am building the macro/s on my home PC (2013 x64) it goes away and I can't seem to find it in the additional add-ins.- Thread
- calendar datepicker excel 2013 add ins x64
- Replies: 2
- Forum: Excel Questions
- Microsoft Monthview Control 6 0 Sp6 Excel 2010 Download 64-bit
- Microsoft Monthview Control 6 0 Sp6 Excel 2010 Downloads
Amazon alexa app. In the posting “Insert a Drop Down Calendar Menu In Excel – Choose a Date!” one of the steps requires that you select the Microsoft Date & Time Picker Control 6.0 (SP4).
Snx file converter. On the dialog box which appears, check the box next to the entry for the Microsoft Date and Time Picker Control 6.0. You'll find that you have access to several other controls from the mscomct2.ocx library as well. Microsoft discontinued the legacy 32-bit calendar control, MSCAL.OCX, in Excel 2010 and replaced it with the new 32-bit Date Picker contained in Active-X library member mscomct2.ocx. Date Picker Alternatives For 64-Bit Office: Several 'private' solutions have been posted on varoius forms. These are not official Microsoft solutions, but users of.
Looking for it? Trying to figure out where to download it from? If it is not installed on your system you can download it here.
To unzip a CAB file simply follow the directions in the posting “A Free Alternative to Winzip or WinRar: 7-Zip”
Once the file is unzipped simply run the MSCOMCT2.BAT batch file!
CategoriesUncategorized
Microsoft Monthview Control 6 0 Sp6 Excel 2010 Download 64-bit
Tags7-ZipCalendarDateDrop DownExcelMicrosoftTimewinrarwinzip Pokemon sun moon rom for citra.