Combo Box Items

macropod · #1 12-12-2013, 04:08 AM

Quote:

Originally Posted by BoringDavid

when the form is launched ComboBox2 always states "Complaints Adjudicator" even if I remove "Complaints Adjudicator" from the module completely.

Not when I do so. There are four such references in your code.

BoringDavid · #2 12-12-2013, 04:50 AM

I've moved all the additems to a Private Sub UserForm_Initialize() as follows:

Code:

Private Sub UserForm_Initialize()
With ComboBox1
    .Value = "UK"
    .AddItem "UK"
    .AddItem "Ireland"
End With
With ComboBox2
    .Value = "Complaints Adjudicator"
    .AddItem "Complaints Adjudicator"
    .AddItem "Complaints Signer/Authoriser"
    .AddItem "Complaints Support"
    .AddItem "Complaints Team Leader"
    .AddItem "Complaints Technical Adviser"
    .AddItem "Office of the Managing Director"
End With
With ComboBox3
    .Value = "Financial Ombudsman Service"
    .AddItem "Financial Ombudsman Service"
    .AddItem "Financial Services Ombudsman's Bureau"
    .AddItem "Pensions Ombudsman"
    .AddItem "Data Protection"
End With
With ComboBox4
    .Value = "sincerely"
    .AddItem "sincerely"
    .AddItem "faithfully"
End With
    TxtClerkName.Text = Application.UserName
 
    TxtCC.Enabled = False
    TxtCC.BackColor = RGB(194, 194, 194)
End Sub

However, when I change the ComboBox2 Value to "Complaints Support", it remains "Complaints Adjudicator" on the userform!

I have attached a blank copy of the document for you to see if I am missing anything!

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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