I have many textboxes in my userform and the userform contains other
controls such as labels ,option buttons and commandbuttons.
I want to read the value of each of my textboxes then decide the Backcolor
of each of them depending on its value.
Thats OK for me, but the problem is that I have to write some lines of code
for each textbox like that

if textbox1.value=.... then textbox1.backcolor=......
if textbox2.value=.... then textbox2.backcolor=......
etc..

Is there a way to loop through my textboxes to shorten my code?

i.e.

for each textbox in userform1.textboxes
if textbox.value=....... then textbox.backcolor=...
next

there is no such a collection as far as I know.

Any suggestions?

Thanks