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

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

--
Rick (MVP - Excel)