DTPicker in Excel 10 doesn't activate on startup
Posted on 2010-11-08
I am using a DTPicker on a Excel Worksheet, one ofr a begin date and one for an end date. The issues I am having are when I open the Workbook, the two controls are not functional and appear with very large font. I can go into Design mode, resize the controls and they work fine.
When I say "not functional" I mean to say they do not drop down and you cannot enter a date. You can however, programatically change the date (Value property) in code as I set the current year Begin date and end date from a button.
I might just remove them and use cells but I am curious why this happens.