backcolor for multiple textboxes

[Marcin4111]

Hi,
I have produced a userform with multiple textboxes.
How should I provide with general code to textboxes.backcolor only for empty texboxes?

Regards,
M

[sktneer]

You may try something like this....

Place the following code on Form Module.

Please Login or Register  to view this content.

And then Call it from the desired command button like this.....

Please Login or Register  to view this content.

[Marcin4111]

Almost works, the only problem is:
Compile error: Invalid use of me keyword

Any alternative?

[sktneer]

How does it almost work if you get a compile error?

Did you place the code on Form Module?

[Marcin4111]

Yes, it is pasted to module form.

I tried to call this code couple of times and twice it worked, this is what I meant saying ALMOST WORKS

When I close userform, then error occurs...

[sktneer]

If the code worked twice that means there is nothing wrong in the code. The problem is somewhere else. I don't know how this code is connected with form close event. Maybe you know better.