P
Phil Hageman
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 user’s 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
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