I am using a user form to input a date into a spreadsheet. The form has a textbox and an OK button. I use the user form initiate subroutine to initially fill the textbox with a date, and I use the OKButton click subroutine to check that the information in the textbox is a date using the Isdate statement. If it is not a date then I use a msgbox to notify me that the date is wrong. My problem is what to do next. I want to put the original date back in the textbox and have the person try re-entering a new date if they wish but I don't know how to jump back to the point before the IsDate statement that would work without jumping to another subroutine that may not bring me back to this subroutine. Just need some guidance on how to do that. I have pasted below the code I am currently using.
ThanksPlease Login or Register to view this content.
Dan
Bookmarks