CODEWITHSUNDEEP
excelexcel-2007ms-officevba
user1292656
user1292656

Reputation: 2560

Auto insert a dropDownList when a new row

I have an excel sheet with three columns. (Name), (Surname) and (Identity Type). The colum identity type can take only 3 values, (Id,Passport,Drivers Licence). What i want is when the user Start writing on new row then a dropdownlist with those 3 values on the column Identity Type should be appeared. Is that possible?. Thanks in advance

Upvotes: 0

Views: 11156

Answers (2)

user10821923
user10821923

Reputation: 1

I know this is old, but instead of selecting a cell for the validation, select the entire column. This will add the validation to all cells in the column and will give you the drop down on all rows as your data expands.

Upvotes: 0

whytheq
whytheq

Reputation: 35577

Not really any need for VBA use Data Validation:

Highlight all the cells in the column which you'd like to add this drop-down into.

The in the Data menu you need to choose Data Validation. You should then get the following and you need to select the three values which you want in the drop-down:

enter image description here

This results in:

enter image description here

Or am I misunderstanding your question ?

Upvotes: 1

Related Questions