I would like to have a column of drop down list boxes referenced to a list
of attendance issues. Say in d1:d10 Sick, sick child, loa, iloa, etc. When I
try to copy them they all change together is their an efficient bit of code
for a situation like this?

Thank you

David

"David Bateman" wrote:
I would like to have a column of drop down list boxes referenced to a list
of attendance issues. Say in d1:d10

How many list boxes are we talking about, and where are they? On a
spreadsheet or on a UserForm?

If the ListBox is on a spreadsheet, look at the listbox's ListFillRange
property. Enter something like Sheet1!D1:D10 in the property.

If the ListBox is on a UserForm, then look at the control's RowSource
property.