so the message based on col c,e
Col B,E you mean...


Add this snippet...
MsgBox "Brand " & Cb2 & " Becomes " & .Cells(Chk, 5)
After
.Cells(Chk, 5) = .Cells(Chk, 5) + Me.Controls("TextBox" & i)