Ben File
07-22-2009, 05:40 PM
Is there a way to count the number of times a person clicks on a button in a user form, and then populate a label with that value until the user form is closed.
What I am trying to do is every time the workbook is opened the information is added to the next blank row. The information added could be x amount of times. The label would count the x amount of times by keeping track of the click event.
See The Attachment.
1. Button = cmdAdd adds the data to the first blank cell.
2. Label = lblrecno would count the cmdAdd button click events.
I hope this makes sense. THANKS in advance.
What I am trying to do is every time the workbook is opened the information is added to the next blank row. The information added could be x amount of times. The label would count the x amount of times by keeping track of the click event.
See The Attachment.
1. Button = cmdAdd adds the data to the first blank cell.
2. Label = lblrecno would count the cmdAdd button click events.
I hope this makes sense. THANKS in advance.