datepicker

  1. kelly mort

    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...
  2. 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...
  3. 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.
  4. H

    DatePicker 32 & 64-bit

    I've found a datepicker https://www.dropbox.com/s/at2peyyhttnbvnw/New%20Calendar%20Ver%204.xlsm?dl=0 I tried to find the way to use the " DTINSERT"-knob to use the date in another Procedure There is a timer event which gets activated in the launch code. When you stop the code midway, the timer...
  5. 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 = Date I have tried a few...
  6. 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 DatePicker is 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...
  7. A

    DatePicker

    Hi I'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.md However, I need the datepicker range to start in column A from Cell 2 so that it doesn't mess up the table header. Here...
  8. krishhi

    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.
  9. G

    Datepicker in a listbox/listview second column

    Hi Is 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.
  10. 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...
  11. 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...
  12. 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...
  13. 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? I’ve read that I need to...
  14. 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?
  15. 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 = Date Thanks
  16. 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...
  17. E

    Vlookup with combox and Datepicker VBA

    I need to borrow someone brain for some help please. Scenario I 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...
  18. 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=kYNaiXmbcoA I am able to get the button to appear on...
  19. 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.
  20. M

    Custom DatePicker and Monthview no installations no add ins

    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...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top