Sorry, but I don't think there is a "Userform_Controls_Change" event. What you COULD do is to create a function to change the control. Then, create an _Exit event for each control that calls the function and pass the control name to the function. That way, you can make 96 exit events, but only one function, then you can modify the function as you see fit...
sorry. Paul ----- Original Message ---- > From: learner <mahessbde...@gmail.com> > To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> > Sent: Wed, October 27, 2010 6:00:42 AM > Subject: $$Excel-Macros$$ Manipulating Userform controls' back color by one >routine instead of separate change routines > > Hi! All Members, > > I am a new member seeking guidance on a problem I can't solve. > > A Userform having 96 Controls (TextBoxes + ComboBoxes) captures data > to create a worksheet. I need to change back color of each control as > data is entered by the user to indicate that the control is already > visited. Instead of writing 96 change routines, I am sure there must > be a simple solution. > > Please advise how to manage it by only one routine. > > Thanks > > Learner > > -- >---------------------------------------------------------------------------------- >- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : >http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
