Start out with fresh with just the one worksheet and just this code for the Combobox1_Change.
Private Sub ComboBox1_Change()
Dim strNewName As String
If ComboBox1.ListIndex > -1 Then 'Test if anything is selected from the list
Range("B22").Value = ComboBox1.Text
strNewName = ComboBox1.Text & Format(Range("I1").Value, "_yy") 'New name
If Not Evaluate("ISREF('" & strNewName & "'!A1)") Then 'Test if worksheet name already exists
Me.Name = strNewName 'Rename sheet
'Prompt to copy invoice
If MsgBox("Do you want to enter another Quote? ", vbQuestion + vbYesNo, _
"Another Vendor") = vbYes Then Me.Copy After:=Me
Else
MsgBox strNewName, vbExclamation, "Vendor Quote Already Exists"
End If
End If
End Sub
Bookmarks