date picker

  1. J

    Date Picker - Validation to only allow workdays

    Hello, I have a User Form with a DatePicker. I want to Add validation so that only future workdays can be selected (excluding both weekends and Holidays). Date Picker name = DTPickerLaunch Validation occurs on command: Private Sub CommandButtonContinue_Click() List of Holidays is located...
  2. J

    Userform DTPicker won't show correct date when feed to cell

    I have a Userform with a Date Picker field called "DTPickerLaunch" When the form is initialized code reads as below so it defaults to today + 30 days (this works fine). The issue is when I transfer the field value to my sheet. On one Userform (UserformScopeLodging) the date is transfer/display...
  3. K

    Malfunctioning: Microsoft Date and Time Picker Control

    Greetings, I have a question for which I cannot find the answer to anywhere. I'm using the Microsoft Date and Time Picker Control in a form at the request of leadership who want to choose the date for the form. The info doesn't go anywhere, it just shows up on print outs. The problem: This...
  4. T

    Auto populate textbox with date according to date in other textbox

    I have a form with a button that puts the beginning and ending date in two textboxes. The start date is named Start_Date_Corp and the stop date is named Stop_Date_Corp. I would like to have another textbox that looks at the Start date and populates with a date that is 24 months prior to that...
  5. A

    Date formatting from VBA Userform Date & time Picker Incorrect

    I'm creating a database in excel where each record has an associated year/period end. I've created a user form to collect the data for each record and the user form contains a date & time picker to set the year end date. The code of my user form writes the date picker value to a global variable...
  6. C

    Formula to Pick latest data based on criteria

    Hi, I wonder if someone could help with a small Excel problem I am experiencing. I have some information in columns A to D . The data in column A is a six digit number (Please note that they are not unique numbers) and If possible I would like a formula to search down the column for the last...
  7. 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...
  8. samrad

    Updated Date Picker Add-in For Excel

    Hey! I made a date picker a while go but just recently refreshed it so I wanted to share it with folks! I think there are a few add-ins that do this already, but I wanted to try and make one a bit more modern looking and use a few extra features like mouse wheel to navigate. It adds a button...
  9. J

    Date Picker not displaying in correct cell when worksheet opened

    Hi Everyone, Hoping I can get some help with this problem (be kind please I'm a first time poster :) ) I have just discovered the date time picker and have inserted it into a spreadsheet. The spreadsheet is saved as a macro enabled template however when I open either the template itself or a new...
  10. B

    Archiving and Retreiving Data

    I have a spreadsheet that has data input into it every day to track daily completions and hours of projects. I am looking for a way to be able to archive (I think that's the right term) the data every day at a certain time (say 11pm) so I can come back and see how much of the project was...
  11. T

    How do I enter Date Picker pop-up on userform

    I have created a userform for entering data on a worksheet. One of the fields is a date and I would like to know how I can enter date picker on that field. I have the Monthview as part of my controls in VBA toolbox but I am unable to integrate it into the userform. I am new to VBA Any help...
  12. G

    Microsoft Date Picker 6.0 and Month View SP6 not on everyones EXCEL - My Macro therefor wont always run

    Hi I am completely new to Excel, but have so far managed to set up a date picker Macro using the Microsoft Month view SP6. However initially neither the Date picker SP6 nor the Month View SP6 controls were available. I had to track them down online and install. However I was disappointing to...
  13. K

    Dates of working days in a month

    Is there anyway that I can populate the list of dates (only working days) in a month? For example: Cell A1 has the drop down list of all the months (Jan to Dec) Cell A2 has the drop down of year (2011, 2012, 2013, ...) If I select "Dec" in A1 and "2011" in A2, then column A3 should have the...
  14. L

    DTPicker Issue

    I have created a userform in Excel VBA that includes a DTPicker. It works fine on my home PC and my work PC. I installed it on another PC at work - for the person who will be using the app, and the code locks up. I commented out the DTPicker lines and it loads now, without the date picker...
  15. T

    Calendar

    I found an Excel Workbook on the web and found it very helpful to create a calendar that has no controls. http://www.tracykaye.com/Calendar10.xls I modified it to this below. http://www.tracykaye.com/NoControlCalendar.xls I am trying to change the look of this calendar. Here is a picture...
  16. T

    Pop up calendar

    I am sharing this with the community as I spent all day trying to find a pop-up calendar that will automatically open up when specific cells are selected. I hope this helps someone that had the same problem I had. I am a complete novice. And I got this to work perfectly... with one exception...
  17. T

    cell formatted pop-up calendar

    When a user enters a cell (merged or not) that is formated with a date format, I want to pop up a button right next to the active date formatted cell? Then I want this button to open a date picker/pop-up calendar right next to the button. Then when the calendar closes... so does the button. I...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top