The control is created & deleted however... the picker drop-down will not work.
Public Sub ShowDTPicker()
If IsDate(ActiveCell) Then
Set dtp = ActiveSheet.OLEObjects.Add("MSComCtl2.DTPicker.2")
.Name = "dtp"
.Top = ActiveCell.Top
.Left = ActiveCell.Left
.Width = ActiveCell.Width
.Height = ActiveCell.Height
.LinkedCell = ActiveCell.Address
On Error Resume Next
Stranger still: after the DTP is created, if i toggle to design mode & manually change any property of the DTP then toggle out of design mode - it works fine.
Strange x 2: If i add a "global" watch for ActiveSheet.OLEObjects(1) after the control is created then i need to do the "Stranger still" procedure twice before the DTP will drop down properly.
My guess was that this has something to do with some kinda "namespace / handle / pointer" holding on to the variable until the manual changes release it. (The random stabs at proper vernacular may have tipped you off that this is beyond my domain. ) i tried setting dtp=nothing, but that did nothing (predictably?)
Thanks in advance for any advice!