Problem to Date and time Picker

They are not installed with all versions of Office. It's much better to use a non ActiveX version, see my examples

Excel DatePickers

Do not mix Visual Basic Classic and .NET Programming. They are 2 very different things.

Thanks all.

Roy,
I have done the setup, per the given Excel file in the download. But after this, I am still getting the same problem.

As I still do not see

Microsoft Date and time Picker control 6.0

within

Developer\Insert\More controls

HuaMinChen,

You are not telling us what version of Windows/Office/Access you are using...

I am using Access 20103/Win 7Pro 64.
...and I get the controls just fine:

.

The examples that I pointed to are replacements for The DatePicker and are for Excel.

From Access 2007 on, there is a built-in date-picker.  It is active whenever a textbox is bound to a field defined as datetime or if there is a date format in the format property of the control for an unbound control.

The DateTimePicker that comes with Access is specific to the Access TextBox. It does not translate to something equivalent in Excel.

Jeffrey's screenshot seems to who that he is working in the VBA Form Designer, while HuaMinChen shows that he is working directly in the sheet.

Although they can both use ActiveX Controls, these environment are different, and in my experience, the list of available controls while working on a sheet is filtered so as not to present controls that do not work in that environment.

Alto, the DateTimePicker shown on Jeffry screenshots is SP4, which seems to show that it is the VB6 DateTimePicker. I did a little search and all the pages I found that described how to use a DateTimePicker with Excel do show a DateTimePicker that looks exactly like the one I was using in the 90's when I was programming in VB6.

To be sure, I checked on 2 computer that have a complete installation of Office 2007, and the DateTimePicker is available only on the machine that also has VB6 installed.

This seems to show that there is no DateTimePicker in Office 2007.

HuaMinChen,
If this is not an Access form, please remove Access from the topic list.  If it is not Excel, then please remove Excel.  The two products use a completely different form model and you are getting different instructions from Access people and Excel people and you are wasting the time of half of the group.  And if the .net people weigh in, you'll be wasting the time of more experts.
Thanks

Many thanks all. I'm using Excel 2010.

James,
Does it confirm that VB6 must be installed, to have DatePicker, within Excel sheets?

Yes, I did get the download file but that does not resolve my problem.

How does it not resolve the problem?

I did run the downloaded file like

but after this, my original problem is not resolved yet.

Use the The Calendar Form example. That is specifically for UserForms

Thanks. Within Calendar Form Excel file, how to move that Calendar button?

To other places.

Not sure what you mean. Which button?

In the example file (like the attached), I do not know how to move the button to other places.
t2.xls

No, do you see "Calendar" button inside Sheet1? How to re-position it?

Within the current attached file.

There's no file attached.

It's simple to move buttons read this. Attach the file if you need , indicate where to move it to

Within "t2.xls" which I uploaded yesterday, can you see the button inside "sheet1"?

Thanks a lot.
Can I copy such button to other Workbook for use? Can I disable/enable it within the macro then?

Read the article about creating buttons that I posted a link to. The example has a CommandButton from the ActiveX controls, you can also use a Shape or a button from the Forms Controls

You will need to move the code and userform to the other workbook unless you create an addin

It seems the button does work as expected, after I've copied it to one other Workbook.

Within the attached file, the button only is working within Sheet 1 but not on Sheet 2. Why?
t3.xls

Pleased to help