| 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) | |||
Hybrid Mode
