This is seriously driving me nuts...how can I make a LDdate control on a user form to input the date value into a cell on the sheet...I've tried all I can think of. I've added the control, the form pops up when the sheet is opened all the other fields input into the correct cells but changing the date control does nothing. PLease Help