easy peasy...
under the line where you set the flag true add
TB.backcolor= RGB(255,255,0)
count= count +1
I think this is yellow, I think white is RGB(255,255,255).
Then for each empty box the color changes. Then the reminder message can be:
msgbox Prompt:="lease fill in the " & str$(count) & " highlighted boxes"
Notes:
You can only see the background color of an object if the BackStyle property
is set to fmBackStyleOpaque.
add a "Dim count as long" and initialize count to zero before looping
through the TB's
You need to clear all six backcolor properties in the form open event.
You need to clear the backcolor property whenever the text is entered in the
text box change event (if not "") for each individual text box.
I think thats it, you gotta play with it.