Have you tried
controlname.forecolor = vbRed
(You can use whatever color you need, rather then red i.e.:vbBlue, vbGreen, vbBlack...)
This works with Visual Basic and also with VBA.
As far as I know, you don't have to unload your form when closing Excel, it will unload when you close the program by default. There may be others who disagree, however.
Hope that helps you.
[ This Message was edited by: JSearcy on 2002-05-03 08:38 ]
Like this thread? Share it with others