I use Word VBA to create templates for my colleagues to use for their letters, we have approx. 70 letters. So to try and standardise the letters I have created a master template with an "Address" userform that will capture information required for all letters, one of the items required is job title. I currently use a ComboBox with a list of the title to choose from.
The majority of our letters are used by our adjudicators so the master template has the following coding in module1:
Quote:
With Address
.ComboBox2.Text = "Complaints Adjudicator"
.ComboBox2.AddItem "Complaints Adjudicator"
.ComboBox2.AddItem "Complaints Signer/Authoriser"
.ComboBox2.AddItem "Complaints Support"
.ComboBox2.AddItem "Complaints Team Leader"
.ComboBox2.AddItem "Complaints Technical Adviser"
.ComboBox2.AddItem "Office of the Managing Director"
End With
|
However, some of our letters are either used by only by our Complaints Support team or primarily used by them. However, when I have amended the coding to this:
Quote:
With Address
.ComboBox2.Text = "Complaints Support"
.ComboBox2.AddItem "Complaints Adjudicator"
.ComboBox2.AddItem "Complaints Signer/Authoriser"
.ComboBox2.AddItem "Complaints Support"
.ComboBox2.AddItem "Complaints Team Leader"
.ComboBox2.AddItem "Complaints Technical Adviser"
.ComboBox2.AddItem "Office of the Managing Director"
End With
|
The UserForm still deafaults to Complaints Adjudicator (I've even deleted Complaints Adjudicator out of the AddItem list and it still appears!)... I have been unable to locate anywhere that maybe affecting this userform. Is there any advice you guys can give me?