Adding date and time picker on the Excel form

**ThePower777** · 06-20-2012, 03:46 PM

Hi everyone!
I am creating VBA application with Excel 2010 and found out that there is not date or time picker control in standard controls tab. Is it possible to add those type of controls on the VBA form?

**Leith Ross** · 06-20-2012, 03:59 PM

Hello ThePower777,

I don't have 2010 but you should be able to add the control from the "Additional Controls...", at least you can in Excel 2003.

With the ToolBox displayed, right click in the lower right corner. This will display a context menu. You should see "Additional Controls..." listed. This open another dialog with all the available controls. look for the "Microsoft Date Time Picker Control" and select it. This will place the Date /Time Picker icon on your ToolBox.

**ThePower777** · 06-20-2012, 04:24 PM

thanks for fast reply, but I have Office 2010 64 bit, and this is the main problem, there is no Microsoft Date and Time Picker Control in Additional Controls window, I tried to register mscomct2.ocx on my system but it is not working.

**Leith Ross** · 06-21-2012, 04:44 PM

Hello ThePower777 ,

The mscomct2.ocx won't work because it is 32 bit. I have not found a a 64 bit version of the control. Maybe some company has created a similar control but I haven't explored that yet.