Date Picker on Excel 365 UserForm textbox

Using Windows 7 Home 64bit - Office 365 (32bit)
I have Googled for ages on this one. There are a million post out there all with a different "solutions" for various versions of Office. I'm really stumped as to how to proceed. Surely the latest, greatest version of office has a sensible, simple solution to this!

I have a Text Box on a UserForm that I want to attach (or whatever the right terminology is) a Date Picker.

Thoughts?
Roy
RzzBAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder than dirtCommented:
I don't use Office 365 but I am very familiar with using the date picker in a userform. With that in mind please let me know if you want the date picker in the textbox (which can't be done) or just have the user's selection show up in a textbox.
Martin LissOlder than dirtCommented:
If it's the latter all you need is this.

Private Sub DTPicker1_Change()

TextBox1.Text = DTPicker1.Value

End Sub

Open in new window

RzzBAuthor Commented:
Well - I have a text box that the user can type a date into. I want to give them the option of using a date picker.

I was thinking of having a small icon adjacent to the text box that brought up a date picker that put's it's output into the text box.  I imagine that's what your TextBox1.Text = DTPicker1.Value is doing.

My problem is getting the date picker on to the form in the first place. There doesn't seem to be a DatePicker in the toolbox.
Become a CompTIA Certified Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Martin LissOlder than dirtCommented:
Right click on the Toolbox and select Additional Controls. Then scroll down to the Microsoft Date and Time Picker control and select it.
RzzBAuthor Commented:
Hmm... I tried Additional Controls but there is no Date Picker.

I'm on Windows 7 Home (64bit) and Office (Excel) 365 (32bit)
Martin LissOlder than dirtCommented:
I did a bit of research and it seems that (unfortunately) the datepicker isn't included in Office 365. Surely however there must be an alternative in the list. If not then some alternatives are available here. Note that I've never used them.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RzzBAuthor Commented:
So it was in earlier versions but not in the latest version? Hmmm - whose idea was that! Wouldn't you just love to be a fly on the wall at the meeting that decided that!

I have been through the additional controls very carefully and there is nothing there  that looks anything like a Date Picker.

How is that list populated - is there a DLL that would give me more options perhaps?

I'll take a look at the alternatives you suggest. Thanks.
RzzBAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for RzzB's comment #a41189704

for the following reason:

I have just tried the Calendar Form from royUK (www.excel-it.com) that you pointed me at. It's working after a few minutes - needs a little fitting in here and there but it's going to be good. Tried to leave some thanks on his web site but the contact us facility is not working.

Many thanks for your help.
Roy
Martin LissOlder than dirtCommented:
Roy, did you mean to choose your post ID: 41189704 as the solution rather than one of mine?
RzzBAuthor Commented:
Hmmm - Nope - how on earth did that happen? I just clicked on the Accept as Solution tab - what do I do now?
RzzBAuthor Commented:
Apologies - I have assigned this to the wrong post. I guess a moderator will fix this?
Martin LissOlder than dirtCommented:
I don't have experience doing it but aren't you able to select a different post now? If not then you ca Request Attention and a moderator will help you.
Martin LissOlder than dirtCommented:
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
including these two new ones.
Creating your own Excel Formulas and doing the impossible
A Guide to Writing Understandable and Maintainable VBA Code
Marty - MVP 2009 to 2015, Experts-Exchange Top Expert Visual Basic Classic 2012 to 2014
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.