Results 1 to 3 of 3

Simplify Long Process Function

Threaded View

  1. #1
    Registered User
    Join Date
    07-13-2011
    Location
    North Carolina, USA
    MS-Off Ver
    Excel 2007
    Posts
    11

    Simplify Long Process Function

    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
    Last edited by imav; 07-13-2011 at 02:06 PM. Reason: title change request

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1