Hi, patel45,

you´re sure about
you created a new Workbook, now ThisWorkbook is NewBook
ThisWorkbook can only be the workbook with code while ActiveWorkbook can be any active workbook (either ThisWorkbook when the code starts or any other workbook).

@simeonmein
If TextBox1.Value = "" Or nullstring Then
MsgBox "Complete All Information!", vbCritical, "Error..."
GoTo error1
End If
I´d guessed to read it like
If TextBox1.Value = "" Then
  MsgBox "Complete All Information!", vbCritical, "Error..."
  GoTo error1
End If
vbNullString and "" should be very very similar to each other but if you want to compare values from a textbox you would need to mention this in both parts of the comparision (you can´t check one textbox for two conditions unless you use Select Case).

Ciao,
Holger