Run-time error: Type mismatch

First, as per forum rules, please wrap any VBA code. The moderators frown upon any code not being wrapped.

The reason you have a Type Mismatch Error is because of this line:

Please Login or Register  to view this content.

This line refers to Range("total"). You cant add a value to a range. What exactly are you trying to do? Do you want to take a sum of the the second column in the totals named range?

If so, amend the line to something like the below:

Please Login or Register  to view this content.

Let us know if that helps.

Thanks for your reply. How do I ensure that the VBA code is wrapped? Please advise.

The book states that:

The purpose of this code is to enable the user to enter a new Rep Name using the textbox(variable is called RepBox), along with the sales for the Rep through the Starting Sales textbox. There is alos a listbox included so that the user can check to see that they do not duplicate the entry of a Rep Name.

When looking at the image and the Excel file that I attached(see worksheet "weeklysales") that references the code, after the Rep Name is entered and four sales amounts are inputted the SalesBox, there should be a new line added just before the Total row.

I have checked the source code to see if I had a typo, but it is exactly how it is in the book.

The author explains later in another passage that the "total" is an object. I am confused.

Is my code formatted the according the forum rule #3?
Can you also open my Excel attachement I posted with my original posting?

Please Login or Register  to view this content.