I've got a strange problem with the Data validation Text Box


Posted by Lori on September 18, 2001 7:08 AM

Does anyone know what this problem may be? I entered a message to display when a cell is selected (in Data Validation. When the cell is selected, the only thing that displays is a black box. No text, or if there is, it must be black, too. Anyone?

Posted by Ben O. on September 18, 2001 7:36 AM


The background color of Data Validation input message boxes is controlled by your display settings in Windows. Go to the Appearance tab of your display settings. Under Item select Tooltip. This might be set to black, or it might be set to some other color that Excel can't render for some reason. Try changing it to basic yellow and seeing if that fixes the problem.

-Ben

Posted by Lori on September 18, 2001 8:33 AM

Thanks Ben,
My IS Dept has disabled the Control Panel. Is there any other way to do this?

Lori


Posted by Ben O. on September 18, 2001 10:39 AM

The only other way to change your display settings would be through your sytem registry, which your IS department has probabaly also made inaccessible (for good reason). But if not, open the registry by selecting Run from the start menu, typing regedit, and then hitting OK. In the Registry editor, go to HKEY_CURRENT_USER\Control Panel\Colors. Change the value of InfoWindow to "255 255 0" (yellow). You may have to restart for the change to take effect.

To check whether or not the tooltip background color is what's causing the problem, look at other tooltips. Let you mouse pointer hover over any toolbar button. Are the tooltip boxes that come up also black? If so, the displays settings are definitely the source of the problem. If not, I don't know what the problem could be.

What version of Excel are you using? I'm using 2000 and there's no place to change to color of the data validation boxes in the Options. If you're using Excel XP, maybe they added that option.

-Ben



Posted by Lori on September 19, 2001 7:48 AM

The other tooltips are black but the font is white.

Ben,
I can read the other tooltips. I have Excel 97 running w/Windows 95. Thanks for the help.
Lori