Hi all, been on holiday, sorry for the delay in responding - the cell on the excel sheet is formatted as a date, but the same thing happens if it's formatted as a number - displaying the date as a number. I've tried using the AddDate function in VB and it still does the same thing if the date is 22/05/08 then adding 2 days gives 24/05/08 both on thre spreadsheet and displays 24/05/08 in the text box on my user form. start with 02/05/08 and the spreadsheet has 04/05/08 but the user form shows 02/07(July)/08.