I have been learning VBA to create an Excel sheet which allows people to easily and quickly grade a diagram that our students must memorize and draw.
I have placed activex textboxes which have colored borders and transparent backgrounds when empty, but turn opaque when a number is entered (textbox_change() events).
I am running into an issue where I have to make thousands of these yet I can only figure out how to implement the change one sub at a time. I have a workaround of copying to word, find and replace, then add to next sub. However, this ends up being very messy and time consuming.
Is there a way to have a single sub/function that implements formatting changes (if not empty-> font color=x, etc.) Or do I have to have an individual sub for each textbox_change() event?
Thank you for your time.
I tried looping through all textboxes on worksheet change which worked, but it checked every box every time which would be very laggy and unresponsive, so it doesnt work as a time-saving measure.
Andy P is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.