I've made a userform with lots of text boxes. is there a way to set the default date format on each box ideally from the VBA editor but by VBA if not. Bare in mind that I'd need some of the text boxes to remain as text not dates. Thank you.