How to limit cell value in Excel to options from another sheet ...

2010年11月10日 - VBA isn't necessary in this case. Use the built-in "Data Validation" feature. Select the cell you want to add the combo box to, and choose Data, ...

stackoverflow.com