userform button click stores a variable (number of clicks)

I'm not sure if this is possible, or if there is a better way to do it...

What I would like to do is in my userform, use my command button that runs all of my code to store a variable that is the number of times it has been clicked.

With this number, I would like to use that to keep track of what the click number was and for that number what the selections in my listbox were.

The selections in my listbox are put into cells on the sheet the macro is on, and these cells are copied to the worksheet called Hist, and this is where I want the copied selections to be matched with a specific mouse click. So each mouse click is associated with one set of copied data. I hope that makes sense. I can post my code, but I just want to get an idea if this is possible or not.

Thank you!

I would like to take the route of storing the value in a cell. How would I go about doing so?

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!