Paulmon,
You can create your list and apply the validation to all cells at one time.
HTH

"Paulymon" wrote:

I want a cell to have a drop down list of options. Do I have to create a
combo box for each cell I want this in, or is there a way to get the cell to
popup a few options when it's clicked?