"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.