View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Changing DATA VALIDATION box color.

The data validation input message appearance is controlled by your
Tooltip settings. To change the font type or colour, or background colour:

(Instructions for Windows XP)
Note: this will also affect ToolTips and Comments

Right-click on the desktop, and choose Properties
On the Appearance tab, click Advanced.
From the Item dropdown, choose Tooltip
Choose a font, font colour, and/or background colour
Click OK, click OK

As an alternative, if you can use programming, you could use a textbox
to display the input message. There's an example he

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'Input Message in Textbox'


gtton wrote:
Does anyone know how to change the DATA VALIDATION box color from yellow
to orange or red (to make the message appear more precautionary)? Any
help is appreciated. Thanks.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html