First ever post!
Hello. I am working on a project that has become rather large and I cant contine splitting processes.
Here is a chunk of code. Is there any way I can simplify it to save on space?
If UserForm1.ComboBox1 = "Haiti" Then
If UserForm1.ComboBox2 = "Port-au-Prince" Then
If UserForm1.ComboBox3 = "Terrorism" Then
TextBox1.Text = Worksheets("xxxx").Range("B64")
TextBox2.Text = Worksheets("xxxx").Range("J64")
TextBox3.Text = Worksheets("xxxx").Range("K64")
TextBox4.Text = Worksheets("xxxx").Range("L64")
TextBox5.Text = Worksheets("xxxx").Range("M64")
TextBox6.Text = Worksheets("xxxx").Range("N64")
TextBox7.Text = Worksheets("xxxx").Range("O64")
TextBox8.Text = Worksheets("xxxx").Range("P64")
TextBox9.Text = Worksheets("xxxx").Range("Q64")
TextBox10.Text = Worksheets("xxxx").Range("I64")
TextBox11.Text = "Port-au-Prince, Haiti"
End If
End If
End If
Bookmarks