We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
8 days, 3 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
How do I add a date picker to a text box in a userform in Excel 2007
Posted on 2014-12-17
How do I add a date picker to a text box in a userform in Excel 2007
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
5
4
2
11 Comments
Active today
What do you mean when you say "add a date picker to a text box"? Do you mean that you want the result of the selection in a date picker to appear in a textbox?
Active today
Here's a few links explaining how to place an ActiveX date picker control into an Excel 2007 worksheet ...
http://www.fontstuff.com/excel/exltut03.htm
http://www.rondebruin.nl/win/s8/win003.htm
http://www.fontstuff.com/excel/exltut03.htm
http://www.rondebruin.nl/win/s8/win003.htm
Active today
Can this be done in a userFormThe second link above says ...
How to Create a userform with a calendar or Date Picker control on it
So it must be possible.
You could also try this free addon ...
http://www.excel-it.com/excel_datepickers.html
Active today
You can achieve what you want by following these steps:
1. Go to the Visual Basic IDE
2. Select or add your userform
3. If the Toolbox does not appear then click 'View' in the menu bar and select 'Toolbox'
4. Right-click on the Toolbox and select 'Additional Controls...'
5. If 'Selected Items Only' is checked, un-check it.
6. Scroll down to 'Microsoft Date and Time Picker' control and select it.
7. The control will now be in the toolbox and you can then select it and draw the control on your userform
8. Finally, add this code
1. Go to the Visual Basic IDE
2. Select or add your userform
3. If the Toolbox does not appear then click 'View' in the menu bar and select 'Toolbox'
4. Right-click on the Toolbox and select 'Additional Controls...'
5. If 'Selected Items Only' is checked, un-check it.
6. Scroll down to 'Microsoft Date and Time Picker' control and select it.
7. The control will now be in the toolbox and you can then select it and draw the control on your userform
8. Finally, add this code
Private Sub DTPicker1_Change()
TextBox1.Text = DTPicker1.Value
End Sub
Active today
I'm not sure which "option" you mean, so please explain. But here is a demo workbook that shows the results of the above steps.
Q-28582649.xls
Q-28582649.xls
Active today
I suggest you use the Change event instead.
But in any case I'm glad I was able to help.
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
Private Sub Calendar1_Change()
TxtDate.Text = Calendar1.Value
End Sub
But in any case I'm glad I was able to help.
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
Featured Post
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Do you use a spreadsheet like Microsoft's Excel? Have you ever wanted to link out to a non excel file on your computer or network drive? This is the way I found to do it!
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Suggested Courses
Course of the Month8 days, 3 hours left to enroll
728 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.