Changing colour of text box when data is added.

Try this...

Add a new userform and 2 textboxes. Paste the following in the userform code module:

Please Login or Register  to view this content.

Add a new CLASS module. Paste the following to the class:

Please Login or Register  to view this content.

Leave all names as the default, the Class should be named Class1. Hopefully you do not have any other classes (Doubtful ) but it's easy enough to change.

Try running that (the userform, not your complete project) and see if you can understand what's going on... The key to this is the declaration using WITHEVENTS in the Class and the array of classes in the userform.

After running once, add another textbox or 2. No coding changes will be needed for the new textboxes to respond to changes. (Hopefully!)

There are two ways to do this.

The simplest is to use a subroutine

Untested Code:

Please Login or Register  to view this content.

You will need 100 of the textbox change sub routines.

But these can be created in excel using another macro and then cut and pasted into visual basic.

Please Login or Register  to view this content.

___________________________________________________________________________________________________________________________________________________________

The Second is to create a new cllass of object.

This shows you how:

http://www.ozgrid.com/forum/showthread.php?t=141695

Use a class to handle the change event for numerous textboxes.