DTPicker controls missing from userform

[Ryan H]

I have a userform with about 20 microsoft date and time pickers. For some
reason, I opended the file this morning and all the DTPickers are missing
from my userform. I can't even find the control in my toolbox to redraw
them. Am I missing a reference, if so, does Excel just delete them from your
userform? What reference in VBA do I have to select or check off to get my
DTPickers to show again?

Thanks in advance!!

 

[ryguy7272]

Very bizarre. I've never experienced this or even heard of such a thing. I
Googled for an answer; your post (here) was about the only that showed up! I
guess there's not much documentation out that that covers this. Do you have
a backup? Probably not, or you could just recover from that, right. Maybe
it’s a memory issue; Excel not starting up right. Can you down the machine,
wait a few minutes, and reboot, then restart Excel? Or, try File > Open >
Click the tiny down arrow on the Open button > Open and Repair > Repair.

HTH,
Ryan--

 

[Ron Rosenfeld]

I have a userform with about 20 microsoft date and time pickers. For some
reason, I opended the file this morning and all the DTPickers are missing
from my userform. I can't even find the control in my toolbox to redraw
them. Am I missing a reference, if so, does Excel just delete them from your
userform? What reference in VBA do I have to select or check off to get my
DTPickers to show again?

Thanks in advance!!

I don't know why the DTPicker disappeared from your file. However, to get it
to show up in the toolbox, right click on the tool box and select to Add
Additional Controls. In the dialog box that opens, look for "Microsoft Date
And Time Picker Control" and select that.

On my system (W7Pro-64bit, Excel 2007) it is in the file
C:\Windows|SysWOW64\mscomct2.ocx

YMMV

--ron

 

[Rick Rothstein]

I have a userform with about 20 microsoft date and time pickers. For some

I don't know why the DTPicker disappeared from your file. However, to get
it
to show up in the toolbox, right click on the tool box and select to Add
Additional Controls. In the dialog box that opens, look for "Microsoft
Date
And Time Picker Control" and select that.

On my system (W7Pro-64bit, Excel 2007) it is in the file
C:\Windows|SysWOW64\mscomct2.ocx

You missed pressing the Shift key for the character between "Windows" and
"SysWOW64" on your line; the statement should be this instead...

C:\Windows\SysWOW64\mscomct2.ocx

 

[Ron Rosenfeld]

You missed pressing the Shift key for the character between "Windows" and
"SysWOW64" on your line; the statement should be this instead...

C:\Windows\SysWOW64\mscomct2.ocx

Thanks for picking that up, Rick.
--ron