in my userform textbox5 contain date and date format is "dd/mm/yyyy" when sheet data (Colmun B) transfer to textbox then date format change automaticly " mm/dd/yyyy" . how to correct change date format " (mm/dd/yyyy) to (dd/mm/yyyy)
but it show error plse help with correct code
and also when textbox5 value (contain date) transfer to worksheet then i shown in left side instead of right side