Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding i new item to current data validation list
Hi, i'm trying to add a new item to validation list. It seems code runs
without errors but the result is a row, not a dropdown list. When I close the workbook and open I can see drop down list. Help please. Code to add "Item3" With Selection.Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertWarning, Operator _ :=xlBetween, Formula1:="Item1;Item2;Item3" .IgnoreBlank = True .InCellDropdown = True .InputTitle = "" .ErrorTitle = "" .InputMessage = "" .ErrorMessage = "" .ShowInput = False .ShowError = False End With |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding i new item to current data validation list
Use commas after each item not semi-colons
Item1,Item2,Item3 Paul "KT1972" wrote in message ... Hi, i'm trying to add a new item to validation list. It seems code runs without errors but the result is a row, not a dropdown list. When I close the workbook and open I can see drop down list. Help please. Code to add "Item3" With Selection.Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertWarning, Operator _ :=xlBetween, Formula1:="Item1;Item2;Item3" .IgnoreBlank = True .InCellDropdown = True .InputTitle = "" .ErrorTitle = "" .InputMessage = "" .ErrorMessage = "" .ShowInput = False .ShowError = False End With |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding i new item to current data validation list
Thanks.
"Paul" wrote: Use commas after each item not semi-colons Item1,Item2,Item3 Paul "KT1972" wrote in message ... Hi, i'm trying to add a new item to validation list. It seems code runs without errors but the result is a row, not a dropdown list. When I close the workbook and open I can see drop down list. Help please. Code to add "Item3" With Selection.Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertWarning, Operator _ :=xlBetween, Formula1:="Item1;Item2;Item3" .IgnoreBlank = True .InCellDropdown = True .InputTitle = "" .ErrorTitle = "" .InputMessage = "" .ErrorMessage = "" .ShowInput = False .ShowError = False End With |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding to a data validation list | Excel Discussion (Misc queries) | |||
Macro to select data Validation List Item | Excel Programming | |||
How do I add an item with comma in the list of data validation | Excel Discussion (Misc queries) | |||
Validation List -adding data and using it later | Excel Discussion (Misc queries) | |||
Help! Selecting item on data validation list switches windows | Excel Discussion (Misc queries) |