I understand that i can add a list box and return the value selected to a particular cell.

However this sheet has more than 100 cells which needs selection.

So how can i have a separate listbox for each cell?

Thanks