Okay right adjust the code as follows:
Open VBA by pressing Alt+F11. Double click on the UserForm1 in the Project Window. This will bring up the userform. Select the Record tab and then right click on the Edit button. Select the View code option.
Scroll through the code until you see the line of text
Replace this line of text with the following:
Be careful not to delete any of the surrounding code.
Select the userform1 from the project window again. Select the first tab "Input Information" then exit out of Visual Basic. Save the workbook and then try to use the form again.
Bookmarks