1) I have created a userform to input data, but i wish to stop people useing a full stop for dates. I.e 16.01.02 instead of 16/01/02 for 16th January 2002, is there anyway i can either use VBA so that as soon as they exit the textbox it changes the . to / or to use VBA to see if the textbox contains . and throw up an error message of my design????
2) I wish to automatically have the 1st of the current month input into a textbox when the userform in initialised, does anyone know how to do this???
Please help!