Macro help - finding and displaying cell values

In this code

Please Login or Register  to view this content.

you are getting the value from column 6, which is F. That's GVWR, not width. Then you get a value from column 13, which is M, which is blank.

You also seem to confusing the two worksheets in your code. Instead of activating a sheet, use explicit qualification for each cell reference.

Also, you are using a MATCH function to look up the position of the selected item, but the ListIndex property of the list already tells you that. ListIndex starts using 0 as the first item so you have to add 1 to get the row number. Also you have a header row, so you have to add 1 again.

You also use intermediate variables where they aren't really necessary. This sometimes make code more readable, but sometimes just makes it bigger.

You seem to be loading the second listbox from the list of trailer GVWR. I think you meant to use the trailer name.

One suggestion, which I didn't implement: You may want to create named ranges for the vehicle and trailer names. Then if you change the way your data is organized, you won't have to change the listbox range source.

Here is how I would write this code, book is also attached:

Please Login or Register  to view this content.

That works great. Thank you so much!

I could not get the way you suggested to work given my code, but the following code allows me to do what I want.

With each click in the userform, the counter and all the information in the click is moved to another sheet called history, and since the information that is copied occupies 2 rows, i want it to skip a row and then continue onto the one after that. Each click stores history based on the number.

The code that I have messes up on the first two clicks. The first click puts the items that were copied in the first spot I want, but then the second click overwrites the first clicks copy. The third click skips a line and copies the information correctly. I do not understand why that is. My code is below:

This code is for the counter...

Please Login or Register  to view this content.

This code is for the copy command.

Please Login or Register  to view this content.

Any suggestions would be appreciated!

With a problem like this you need to attach your whole workbook. I can't see what happens when you click a button.

I could not get the way you suggested to work given my code....

I am very puzzled by this seeing as though I didn't just make a suggestion. I took your workbook, fixed it, and then posted the completed solution. What did you post if it wasn't your code?

I apologize, I posted this is in the wrong thread. I meant to post it in my other thread.