Forum Discussion
Solved
Update (refresh) cell after programatically change the data validation
Hello to all, I have the following lines of code that work fine in setting up a new validation type for cell E4. Range("E4").Select
With Selection.Validation
.Del...
That is the expected behavior. Changing the source of the data validation list does not affect the cell value, even if that value is no longer valid. Excel cannot know what the new value should be.
You could do this:
With Range("E4") With .Validation .Delete .Add Type:=xlValidateList, Formula1:="=CTRYS_MOV_ANO" End With .ClearContents End With
Do you mean that the users don't see the new data in the drop down list?
Hello Hans,
No, they do not see the new list. The cell still shows the value of previous/validation (or selection). Only by clicking the cell the new values get available.
Octavio
No, they do not see the new list. The cell still shows the value of previous/validation (or selection). Only by clicking the cell the new values get available.
Octavio
That is the expected behavior. Changing the source of the data validation list does not affect the cell value, even if that value is no longer valid. Excel cannot know what the new value should be.
You could do this:
With Range("E4") With .Validation .Delete .Add Type:=xlValidateList, Formula1:="=CTRYS_MOV_ANO" End With .ClearContents End With- Hello Hans,
I posted before reading your last advice. It is quite a good solution. Many thanks for your help.
Octavio