Drop Down List Excel

[ziad alsayed]

Dear all

I am using a drop Down List that has 3 options "Normal","N/A" and "RedWings", it is named "Safety" in the name manager.
the issue i am facing is the i do not know the number of row i will be using, so i dont want to select range and add to drop down list to it.

is there a way let say if i add data to a new row it will automacilly add the drop down in colmun D and i will choose from the 3 options.

 

[Andrew Poulsom]

Say you have a dropdown in D1 and D2. If you insert a row at row 2 a dropdown will also appear in the new D2, so now you have dropdowns in D1:D3. At least that's what happened for me in Excel 2003.

 

[ziad alsayed]

dear andrew


i am using excel 2010, my drop drow is only in column D, i only use it for some cells in column D, i do not know how many cells i will be using in this column,
let say i used the drop down in column D for 5 cells, so normaly it will not appear in row 6 ( cell D6). now let i added some data in row 6 , i want it to appear automatically in D6 and i will choose from the options.

it is not the sames you faced , but thanks for the reply.

 

[antaeusguy]

You may give a name to the range to D1:D5, e.g. "DropDownList"
then in the validation, enter the named range instead of D1:D5
Create a macro in the Sheet Change Event in ThisWorkbook:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Range("D1").CurrentRegion.Name = "DropDownList"
End Sub