Sorgu için arama sonuçları: xlValidateList

...ThisWorkbook kod sayfasina: Private Sub workbook3_open() With Range("g31").Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween, Formula1:="C24,C30,GL 24h, GL 28c, GL 32c, GL 28h, GL 32h, GL 24c, GL 36c, GL...

....ShowError = False End With boyler = deger*5 Case "2" With boyler.Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween, Formula1:="300;400;500" .IgnoreBlank = True .InCellDropdown = True...

Merhaba, aşağıdaki kodda '.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Formula1:="=baslik" ' satırında hata oluşmakta ve vaidation yapılamamaktadır. Yardımlarınızı rica ederim Ahmet Sub dogrulamaliste() Dim baslik As String Dim son As Integer Dim rName As Name For Each rName In...

...Name:="ad", RefersToR1C1:="=Sayfa2!" & adr [b4].Select With Selection.Validation .Delete .Add Type:=xlValidateList, Formula1:="=ad" End With If Target.Address <> "$A$4" Then Exit Sub On Error Resume Next Set s1 = Sheets("sayfa3") ilksat =...