I have a data validation field that refers to a range. When I make a selection in the list, the font is changing to a different color. It happens in four out of six fields that have data validation, and they all are set up the same way in VBA code. There is no conditional formatting applied to any of them. If it was a drop-down control, I would think the color change is coded in the change event, but it's a simple data validation field. Did anyone have the same issue?
Not experienced it myself.
Could we see the workbook?
BSB
No, it's a confidential workbook.
OK. I can't help then.
Difficult to diagnose without the workbook....
Maybe someone else has a crystal ball and can help.
OR you could desensitize the data and then attach the workbook... Just a thought.
BSB
Not something I've experienced either.
If you want help, make a copy of the workbook, desensitize the data ... and we only need enough data to see the problem, make sure the issue still presents itself, and upload the copy.
In deference to BSB, failing that, we can perhaps ALL put the ubiquitous Crystal Ball on our Christmas Lists.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
At a minimum, can you post the Data Validation Rules as they are and the Applies To field for each rule?
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Hi I have a problem with my LOGSHEET (please see attachment). User is able to delete the contents of the cell J12 or the selection from the drop down.
I want user to choose only from the drop down and not to delete the contents of the cell.
What I did is locked the cell and protect. User cannot delete the contents but cant choose from the drop down contents also.
I don't know what to do anymore. please help.
Thanks.
TIMETABLE - NEW.xlsm
Capture.PNG
@ruissu: Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks