I am using the following short macro to assign Data Validation as a list of characters:
Sub DVList()
With ActiveCell.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="a,b,c,d"
.IgnoreBlank = True
End With
End Sub
The macro works.
I want to modify the macro to include the comma character in the list. I don't see how to do this because the comma is the list separator.
Am I stuck having to use worksheet cells to build the list??
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…