ExcelBanter - combo boxes in many sheets

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - combo boxes in many sheets (https://www.excelbanter.com/excel-programming/297886-combo-boxes-many-sheets.html)

kanan

combo boxes in many sheets

hi
I have a combo box in each one of my sheets from the forms toolbar and I have a macro assigned to it. Is there any wa
to determine the combo box name based on the sheet name and instead of hardcoding. I need to load this box wit
different values in each sheet. Any ideas or documenation would be greatly appreciated
thanks
Kanan

All times are GMT +1. The time now is 09:46 AM.