Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populate xlValidateList; Please Comment
Hello,
I am seeking a way to specify the validation formula1 with a string. The values themselves my contain commas. With Names(NamedRange).RefersToRange .Validation.Delete .Validation.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="10,000, 11,000" .Validation.IgnoreBlank = True .Validation.InCellDropdown = True .Validation.InputTitle = "" .Validation.ErrorTitle = "" .Validation.InputMessage = "" .Validation.ErrorMessage = "" .Validation.ShowInput = True .Validation.ShowError = True End With Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populate xlValidateList; Please Comment
I think you'll have to put that list in a range on a worksheet (hidden sheet and
the range nicely named) if the values will include commas. AMDRIT wrote: Hello, I am seeking a way to specify the validation formula1 with a string. The values themselves my contain commas. With Names(NamedRange).RefersToRange .Validation.Delete .Validation.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="10,000, 11,000" .Validation.IgnoreBlank = True .Validation.InCellDropdown = True .Validation.InputTitle = "" .Validation.ErrorTitle = "" .Validation.InputMessage = "" .Validation.ErrorMessage = "" .Validation.ShowInput = True .Validation.ShowError = True End With Thanks in advance. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
How can I edit a comment w/o first having to select Show Comment | Excel Discussion (Misc queries) | |||
How do I insert a comment when the Insert:Comment menu is greyed? | Excel Discussion (Misc queries) | |||
Populate | Excel Programming | |||
a comment plugin & copy paste directly from excel to comment ? fr. | Excel Worksheet Functions |