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.