LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
CH CH is offline
external usenet poster
 
Posts: 49
Default Data Validation Error

I have a spreadsheet with multiple drop down selection boxes setup using Data
Validation, which all reference different lists.

The problem I have is that one of the dropdown arrows for the validation box
is always visable even when the cell is not selected. For the dropdown to
work properly, the cell must be selected.

I've tried clearing and resetting the Data Validation for this cell, but the
dropdown arrow always remains (even when the validation is completely cleared
off).

Any thoughts on what might be causing this, or how to fix?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error message when trying data validation Cam1234 Excel Discussion (Misc queries) 3 April 1st 08 11:28 PM
Data Validation error Kristen Excel Discussion (Misc queries) 2 February 7th 08 02:36 PM
Data Validation Error Dileep Chandran Excel Worksheet Functions 7 November 8th 06 12:22 PM
#VALUE# error with Data Validation KG Excel Discussion (Misc queries) 1 May 28th 05 05:31 AM
Data Validation error ?? Anthony Excel Worksheet Functions 1 February 10th 05 03:52 PM


All times are GMT +1. The time now is 06:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"