Cell Validation Not Responding

A

Ark68

Well-known Member
Joined
Mar 23, 2004
Messages
4,570
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
I am having a problem.
I have a validated cell that I copy from one protected worksheet to another.
At the source, the cell's list validation works. Click on the cell and the little arrow shows.
However, at the target worksheet, the user can click on the cell (which is unlocked) but their is no little arrow. Checking the cell's properties indicates that there is cell validation in place.

Any idea why I don't have the list validation function?

I can type in the selected cell, and any invalid entry (according to the validation list) will trigger the error message. So the validation list is there, just no option for the drop down.

Jenn
 
Last edited:

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Sort by date Sort by votes
Have you checked the cell's .Validation.InCellDropDown property?

If the cell works properly when True, what is its .Validation.Formula1 property?
 
Upvote 0
If this is the worksheet data validation, did you check to see if the In-cell dropdown check box is unchecked?
 
Upvote 0
Hi Guys,

According to the properties, "In-Cell Drop down" is checked in all instances, on both worksheets.

Like I mentioned, it works fine on the source worksheet, little arrow appears. But when the same cell is copied to the second worksheet, although selectable by the user, there is no arrow.

Jenn
 
Upvote 0
Is the reference to a range of cells or is it a named range?

Where is the reference? Is it on the source worksheet?
 
Upvote 0
Yes, it is a named range. It refers to a range on a third worksheet.
Works fine on the source, and the validation works on the target to. Just no arrow. Type in something not part of the named range and you get an error.
 
Upvote 0
Honestly Jenn I do not know what else to say.

Did you open a blank sheet and try again?

I hope somebody else will have some advice to offer...
 
Upvote 0
Awww ... thanks for your help guys!!

Its a mystery to me as well ... it had worked, until I changed the destination cell. The original cell worked, but this one, not so much.

Oh well. I'll see if I can get it back to the way it was.

Jenn
 
Upvote 0
Stumped. Even after I (think) returned things back to the way they were when it worked, it no longer works.
 
Upvote 0
What is odd ... is I can't get a drop down validation list to work anywhere on the destination sheet. I've been randomly placing list validation rules in this worksheet with no results in the form of a drop down arrow. The validation works, just no list to select from.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Solved
Data Validation question
Replies
4
Views
255
Peter_SSs
Peter_SSs
A
  • Solved
Missing Worksheet with Data Validation List Options
Replies
1
Views
142
ajm
A
N
  • Question Question
Data Validation using a SPILL range
Replies
3
Views
373
Nicole Jones
N
M
  • Question Question
Not running code
Replies
0
Views
207
MagicCarpet
M
M
  • Question Question
Data Validation using VBA and Excel function
Replies
0
Views
368
ManUBlueJay
M

Forum statistics

Threads
1,223,914
Messages
6,175,351
Members
452,638
Latest member
Oluwabukunmi

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top