Free Date Time Picker for Excel

Are you tired of manually entering dates in your Excel spreadsheets? Do you wish there was an easier way to select a date without having to type it out every time? Look no further! In this article, we'll show you how to add a free date time picker for excel that makes selecting dates a breeze.

First things first, you'll need to create a userform in your Excel project. Right-click on the 'Tools' menu and select 'Add additional tools.' From there, enable the control by clicking on the 'Microsoft Windows Common Controls -2 6' option.

Once you have the control enabled, start creating your userform. You can customize it however you like, but for this example, we'll keep things simple. Add a label to the top of the form with the name 'lblUF' and another label below it with the name 'lblCtrlName.'

Next, add a date picker control to the form. This is where the magic happens! You can customize the appearance of the control by changing its properties in the Properties window.

When you double-click on the control, you'll see some code that's generated for the DateClick event. Don't worry too much about this code - we'll get back to it later.

Now, let's talk about how to use this date picker control in your Excel project. To do this, you'll need to create a subroutine that will send the selected date to another worksheet or cell. We can do this by adding some code to the DateClick event.

Here's an example of what the code might look like:

```

Private Sub fCal_DateClick(ByVal Canceled As MSForms.ReturnBoolean)

Dim ufName As String

Dim ctrlName As String

ufName = lblUF.Caption

ctrlName = lblCtrlName.Caption

' Do something with the selected date here

End Sub

```

This code simply takes the caption of the two labels we added to the userform and stores them in variables. You can then use these variables to send the selected date to another worksheet or cell.

That's it! With this free date time picker for excel, you'll never have to manually enter dates again. Just create a userform with the date picker control and add some code to handle the DateClick event. Then, whenever you need to select a date, just click on the control and choose your date from the calendar.

Bonus Tip: You can also use this date picker control to create a printable calendar based on an Excel calendar template. Simply loop through all userforms in your project until you find one that matches the label for the Userform (lblUF) and the label for the textbox needed (lblCtrlName). Then, send the selected date to another worksheet or cell.

We hope this article has been helpful in showing you how to add a free date time picker for excel to your projects. With a little creativity and some coding know-how, you can create all sorts of useful tools and features to make your life easier as an Excel developer. Happy developing!

Free date time picker for excel