TextBox2 gets disabled because of the sub - Sub NewPartNumber(newstring As String). In it - UserForm1.TextBox2.Enabled = False is being set to disabled. This is why it wont allow you to click into it if you once passed an invalid newstring.