Microsoft Date and Time Picker on 32 bit Excel 2013 - control not functioing as expected

[ktielens]

I just installed the Microsoft Date and Time Picker Control 6.0 (SP6) onto my Excel 2013 (32 bit). However, when I place it on my worksheet, something strange happens. To place it I perform the following steps:

Developer tab
Insert
ActiveEx more options
Microsoft Date and Time Picker Control 6.0 (SP6)
Draw the picker onto my form


When I click out of design mode to test the function, a duplicate of the picker shows up "floating" slightly above and to the left of A1 (does not matter where I placed the original control). This "floating" control is the only thing that allows me to pick a date or time. In addition there is a floating red circle around the current day, and another one randomly shows up next to the bottom line where it says "Today: XX/XX/XXXX". When I click out of design mode, the "floating" picker disappears, and the picker I actually placed is nonfunctioning.

The code for the picker is below.


Private Sub DTPicker21_CallbackKeyDown(ByVal KeyCode As Integer, ByVal Shift As Integer, ByVal CallbackField As String, CallbackDate As Date)

End Sub


This is a blank worksheet, so it has no other code. Does this indicate a problem with the installation or registration? Is this a known defect? Any help or direction would be appreciated.

 

[SpillerBD]

When I click out of design mode, the "floating" picker disappears, and the picker I actually placed is nonfunctioning.

Under the Developer Ribbon, in the XML section use "Expansion packs" to attach the "Microsoft Actions Pane 3"

 

[ktielens]

Under the Developer Ribbon, in the XML section use "Expansion packs" to attach the "Microsoft Actions Pane 3"

Thanks. Is this something I need to do this every time I use the control?

 

[SpillerBD]

For every sheet or Template. I recently discovered trying to create a Template, which helps.
You could also change the default template(s) to include that to keep things simple in the long run.

 

[ktielens]

For every sheet or Template. I recently discovered trying to create a Template, which helps.
You could also change the default template(s) to include that to keep things simple in the long run.

Thank you for your help!