UserForm to close when user selects 'enter data to spreadsheet'

Hi,

Below is my code.

The code generates a unique number in 'NameTextBox' each time the customer opens the 'Add Record' Userform and the code won't allow the customer to close the UserForm without entering a date value into 'TextBox12' . This is fine and it works correctly.

The issue I have is that the customer can hit 'Enter Data to Spreadsheet' multiple times in the UserForm, this enters the same data to the spreadsheet. I only want them to be able to enter this data once. Ideally the UserForm would close once the customer selects the 'Enter data to Spreadsheet' button, however, I don't want the UserForm to close without them entering the date value in 'TextBox12'. The 'Enter Data to Spreadsheet' button is the 'OKButton' Command Button.

Any help is greatly appreciated

David

Please Login or Register  to view this content.