Hello
I have multiple change event Private Subs for many textboxes in my userform, such as:
I tried combining these into one Change event but it doesn't seem to work. Is that because it just won't work or is there a way around it?
Please Login or Register to view this content.
Please Login or Register to view this content.
Hi,
Have you created control array of textboxes or is it normal textboxes?
Check the below links:
For Control array of textboxes:
http://p2p.wrox.com/access-vba/37472...l-changed.html
For Normal TextBoxes:
1) http://www.mrexcel.com/forum/excel-q...same-code.html
2) http://codereview.stackexchange.com/...out-sacrifices
Regards,
Paresh J
Click on "* Add Reputation" as a way to say thanks
You can't have one change event but you could have one routine that updates all the textboxes and call that from the change event of each one. Not sure if that applies to what you're trying to do though.
Everyone who confuses correlation and causation ends up dead.
I have recently written up information on using a central event handler.
http://www.andypope.info/vba/ufevents.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks