Combo Box Items

fumei · #1 12-12-2013, 03:22 AM

Code:

 Private Sub UserForm_Initialize()

Code:

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

So there you go, ComboBox2 has the items. You have a combobox with things the user selects. They still can. If you want to force something, then do not give them a list to choose from. What is the actual problem?

Quote:

when I need ComboBox2 to state "Complaints Support"

But why? Why do YOU need it to state Complaints Support; the combobox is there for the user to choose.

I have to strongly agree with macropod, the structure is poor. Try to use indents. There are a few other issues ( using Selection for the bookmarks, perhaps using Select Case rather than IF statements...), but I understand this is new thing for you and do not want to overly comment.

BoringDavid · #2 12-12-2013, 03:31 AM

Quote:

Originally Posted by fumei

So there you go, ComboBox2 has the items. You have a combobox with things the user selects. They still can.

Thank you!

Quote:

Originally Posted by fumei

If you want to force something, then do not give them a list to choose from. What is the actual problem?

Quote:

when I need ComboBox2 to state "Complaints Support"

Quote:

Originally Posted by fumei

But why? Why do YOU need it to state Complaints Support; the combobox is there for the user to choose.

It is for documents that are primarily used by our Complaints Support team, but could be used for others, this way it will pre-populate with the most likely choice but gives the option of using a different one if necessary.

Quote:

Originally Posted by fumei

I have to strongly agree with macropod, the structure is poor. Try to use indents. There are a few other issues, but I understand this is new thing for you and do not want to overly comment.

Thank you agin for your help!

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