Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-11-2013, 04:37 AM
BoringDavid BoringDavid is offline Combo Box Items Windows XP Combo Box Items Office 2010 32bit
Novice
Combo Box Items
 
Join Date: Sep 2013
Posts: 19
BoringDavid is on a distinguished road
Default Combo Box Items

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?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Combo Box Items Combo Box Hinchy Word 4 09-04-2012 05:31 AM
combo box in word wperry Word 1 03-22-2012 06:53 AM
Combo Box in whole column ioustinos Excel 1 09-01-2010 01:24 AM
Outlook 2007 Saved sent items list only holds the last ten items david.peake Outlook 0 06-01-2010 07:27 PM
Bold list items in a combo box DrewB Word VBA 0 07-17-2009 11:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:10 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft