Kyle123
Valued Forum Contributor

all sorted. i had somwe code which clears the user form including the date box. i have changed this so when the form is cleared the date shown is todays date.

cheers

property = false.

hmm thats strnage. on the properties for the date picker i can set the checkbox to false but when i try and run the form it comes up with a run time error 35787 "cant set value to null when checkbox

Hi Kyle,

thanks again for your help yesterday with the date picker. just one thing.. i dont want the checkbox to be present on the date picker because if it is unchecked by the user on the form it comes up saying invalid use of null?

is there any way we can chnage this so either a) i dont have the checkbox at all or b) it does not error out if they uncheck the box?

cheers

Matt

Kyle. Thanks for your help. Only problem is I'm a beginner. So I'll welcome a step by step procedure in cracking this problem. Regards

Hi Kyle,

A few weeks ago you helped me with a problem (http://www.excelforum.com/excel-2007...-into-one.html). Your solution is the best I have, but the problem with it is that the answer sometimes contain a lot more letters and interpunction. Sometimes full sentences. Do you think there is a possibility to adjust your formula somewhat so that it can handle more than just a letter? Thank you very much in advance!

Moli