Use a simple Drop Down List or User Form
 

Would someone tell me if I could populate a Cell with a Drop-down list
populated from an Access Table? or could I use a User Form. I would like to
populate Cells in a Column, specific to the Column Header names (e.g. Cell A1
would pull a List from an Access table where Cell B1 would pull from a
different table).
Ted