I am using the DateTime picker and it will not hold the custom format even though it shows it has not been changed in the DTPicker properties. I have tried hard coding using dtpicker1.customformat but that doesn't hold either. Is it possible to create a date/time picker without using the activex control? Whenever I open the document it says active content disable so I select enable then add-ins disabled so I enable that and then I get unexpected error please restart if continues--which I have done.
When I open the sheet the picker shows only the date in long format not date and time. Under properties, I checked: enable, checkbox and updown. I've noticed the value box gets unchecked each time I save and reopen the sheet. Format is set to custom and the custom format is MM/dd/yyyy HH:mm:ss tt. The tt was added in hopes that it would save the format. any help would be apprieciated with correcting this fault or just writing a vba code without using the activex to have 105 rows user select date and time in the same cell.
When I open the sheet the picker shows only the date in long format not date and time. Under properties, I checked: enable, checkbox and updown. I've noticed the value box gets unchecked each time I save and reopen the sheet. Format is set to custom and the custom format is MM/dd/yyyy HH:mm:ss tt. The tt was added in hopes that it would save the format. any help would be apprieciated with correcting this fault or just writing a vba code without using the activex to have 105 rows user select date and time in the same cell.
