PC Review


Reply
Thread Tools Rate Thread

Adding i new item to current data validation list

 
 
KT1972
Guest
Posts: n/a
 
      14th Feb 2009
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 With Quote
 
 
 
 
Paul
Guest
Posts: n/a
 
      14th Feb 2009
Use commas after each item not semi-colons
Item1,Item2,Item3
Paul

"KT1972" <(E-Mail Removed)> wrote in message
news:A848640E-D971-412C-88A3-(E-Mail Removed)...
> 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 With Quote
 
KT1972
Guest
Posts: n/a
 
      15th Feb 2009
Thanks.

"Paul" wrote:

> Use commas after each item not semi-colons
> Item1,Item2,Item3
> Paul
>
> "KT1972" <(E-Mail Removed)> wrote in message
> news:A848640E-D971-412C-88A3-(E-Mail Removed)...
> > 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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding to a data validation list Josh Craig Microsoft Excel Misc 2 30th Jun 2009 02:59 AM
Macro to select data Validation List Item Corey Microsoft Excel Programming 1 24th Nov 2008 12:19 PM
How do I add an item with comma in the list of data validation bhavna Microsoft Excel Misc 9 2nd Oct 2008 04:13 PM
Validation List -adding data and using it later =?Utf-8?B?UE9D?= Microsoft Excel Misc 1 23rd Jul 2006 05:40 AM
Help! Selecting item on data validation list switches windows Kevlar Microsoft Excel Misc 0 28th Feb 2006 10:35 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:03 AM.