ExcelBanter - Locking combo box into a specific cell?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Locking combo box into a specific cell? (https://www.excelbanter.com/excel-worksheet-functions/216929-locking-combo-box-into-specific-cell.html)

driscolp

Locking combo box into a specific cell?

I am using a combo box as a drop down menu for an order form. I would like
this box to lock into a specific cell so that I can run a macro copying its
selection to another form. Right now the combo box just floats on top of the
worksheet. How do I make this part of the worksheet?

All times are GMT +1. The time now is 12:00 AM.