I have a userform with a "Submit" button on it. Ever time the user clicks on the button, I want to increase a counter variable by 1. How can i do this? It seems like either VBA won't let me pass arguments by value into a SubmitButton_Click() event, or I have no idea what I'm doing and I need a tutorial on passing arguments by value.
Please help!
ActiveX Commandbutton Click event handlers don't accept any arguments. Instead, you can declare a static variable inside the event handler and increase the value it holds by one each time the event handler is called. Static variables retain their values between calls.
Please Login or Register to view this content.
Thanks Colin. That worked perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks