Help xlValidateList by VBA

[Maurizio]

Hi all,

into "C9" I need input ONLY 4 % values:

0
4%
10%
22%

with vba I can't get european format: 0,04 not 0.04 (comma NOT dot)


With Range("C9").Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="0;0,04;0,1;0,22"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = "Error VAT!"
.InputMessage = ""
.ErrorMessage = "Attention % Iva ok are:" & Chr(10) & "0" & Chr(10) & "4" & Chr(10) & "10" & Chr(10) & "22"
.ShowInput = True
.ShowError = True
End With

Any ideas?
Tia Maurizio

 

[CSmith]

Does this help? Also AFAIK your code will work once you change those setting

Book1
	C
9	22%
MrExcel Help - Maurizio

Cells with Data Validation
Cell	Allow	Criteria
C9	List	0;0,04;0,1;0,22