Cell drop down lists won't work when new row is inserted.

[alexander.small]

Hi,

In my workbook I have several tabs, the first two contain tables that will eventually have data entered into them by various people at my work. In some of the columns in the table are drop down lists to make it a bit more user friendly and to save time. I have several buttons that do various different tasks, one of which is adding a new row to the table and automatically adding in two bits of data to the table.

My problem is that when I use this button, the drop down lists do not appear in these new rows.

I have attached a copy to help show you what I mean.

Columns A, H, K & L are the columns that have drop down lists. I have clicked both of the buttons a few times to show what I mean about the new rows not having the lists. Rows 11 - 20 do not show the lists, but from 20 onwards do.

Sorry for any unclear explanations, thanks

[Bhuvi]

Hi Alexander,

The problem is while inserting a new row it copies the formtting from the previous row to the new row which doesn't include validation. The validation is in the next rows.

I have added a code which is copying the validation from row12 to row 11.

Please Login or Register  to view this content.

I hope this works for you.

<If this helped , Please click on the * Star below this post to add some reputation>

[alexander.small]

Hi Bhuvi, sorry I've only just seen your reply.

It works perfectly, thank you very much! Much appreciated.