Microsoft Office Forums - View Single Post

fumei · 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.