Programmed ComboBoxes
 

I need to set up a series of ComboBoxes that are controlled programmatically in a centralized location (located in the This Workbook module?). The workbook will be distributed to 33 different users, and I only want to make changes in one place in each users workbook. Any other suggestions would be appreciated

The workbook has 12 worksheets (among others) named
€œRationale 1.1€�, €œRationale 1.2€�, €œRationale 1.3€
€œRationale 2.1€�, €œRationale 2.2€�, €œRationale 2.3€
€œRationale 3.1€�, €œRationale 3.2€�, €œRationale 3.3€
€œRationale 4.1€�, €œRationale 4.2€�, €œRationale 4.3€

On each €œRationale€� worksheet has a ComboBox1 inserted from the Controls Toolbox. The ComboBox dropdown must present six selections
€œT 1€�, €œT 2€�, €œR 1€�, €œR 2€�, €œR 3€�, €œR 4

User selection results in the following

ComboBox Text inserted in Text inserted i
Selection merged Cell range M6 merged Cell range N3

T 1 Develop workforce Execute transformatio
T 2 Fully integrate Execute transformatio
R 1 Develop ability Ongoing requirement
R 2 Planning Process Ongoing requirement
R 3 Decision making Ongoing requirement
R 4 Agency partnerships Ongoing requirement