Code:RefGTW_Date_txt = CStr ( CDate(GTW_Date_txt) + 28 )
I have two text boxes on a userform one you manually enter the date and the other automatically calculates the date 28 days in advance. This works until you try and change the date in the manual text box then I get a Type Mismatch error
Can anyone help please
Code as follows:
ThanksCode:Private Sub GTW_Date_txt_Change() RefGTW_Date_txt = CDate(GTW_Date_txt) + 28 End Sub
Last edited by Miss KF; April 12th, 2006 at 20:23.
There are currently 1 users browsing this thread. (0 members and 1 guests)