Rlb53
09-02-2011, 06:52 PM
Hello All,
Within a Userform Data is being entered.
The Date associated with the Data may not coincide with the current date.
Utilizing DTPicker in the userform I want to force the user to check the date prior to the data being accepted.
I have activated the Checkbox feature.
I cannot get the "IF" command to recognize the lack of the checkbox being initialized as a "Nullstring".
How may I get a result from an unchecked DTPicker that will allow the "If" command to exit sub until the Date is confirmed ?
I'm hoping for something along the lines of:
If dtpicker1=nullstring then
msgbox"Confirm the Selected Date"
dtpicker1.setfocus
exit sub
end if
Thank you for your help !
Within a Userform Data is being entered.
The Date associated with the Data may not coincide with the current date.
Utilizing DTPicker in the userform I want to force the user to check the date prior to the data being accepted.
I have activated the Checkbox feature.
I cannot get the "IF" command to recognize the lack of the checkbox being initialized as a "Nullstring".
How may I get a result from an unchecked DTPicker that will allow the "If" command to exit sub until the Date is confirmed ?
I'm hoping for something along the lines of:
If dtpicker1=nullstring then
msgbox"Confirm the Selected Date"
dtpicker1.setfocus
exit sub
end if
Thank you for your help !