Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
and i can't figure out why...
cells in range j15: j20 contan test values 12,34,56,78... Private Sub CommandButton1_Click() With Range("J24") .Borders(xlEdgeLeft).Weight = xlThin .Borders(xlEdgeRight).Weight = xlThin With .Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertWarning, Operator _ :=xlBetween, Formula1:="=$j$15:$j$20" .IgnoreBlank = True .InCellDropdown = True .InputTitle = "lit title" .ErrorTitle = "waninng title" .InputMessage = "input message" .ErrorMessage = "warning messge" .ShowInput = True .ShowError = True End With End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Method Add of object Validation Failed - please help | New Users to Excel | |||
Method Add of object Validation Failed - please help | Excel Worksheet Functions | |||
Failing IF Statement | Excel Discussion (Misc queries) | |||
Data validation, cell protection or other method? | Excel Discussion (Misc queries) | |||
Macro failing | Excel Programming |