Yes, after the error msgbox, my msgbox appears "TimeToMove = "
That is because in quotes "TimeToMove = " is a string, message box data is a string in all cases and when you use variables of mixed type (integer, double, date) they are converted to strings. It is likely the comma and object that are screwing it up. You are asking the message box to display an object which it can not do. It needs a string. What is it you want the message box to display?
Yes, after the error msgbox, my msgbox appears "TimeToMove = "
That is because in quotes "TimeToMove = " is a string, message box data is a string in all cases and when you use variables of mixed type (integer, double, date) they are converted to strings. It is likely the comma and object that are screwing it up. You are asking the message box to display an object which it can not do. It needs a string. What is it you want the message box to display?
