Excel freezes userform on Launch but ok in VBA

03856me

03856me

Active Member
Joined
Apr 4, 2008
Messages
297
I have a userform that has a large number of rows of code that are included in the Initialize event. I can run the userform perfectly from the VB application but when I run it from the macro included below it freezes Excel. Any ideas? using Excel 2013

Code: 
Sub StartNew()
    Application.ScreenUpdating = False
        With Frm_StartNewPOmatrix
            .StartUpPosition = 0
            .Left = Application.Left + (0.5 * Application.Width) - (0.5 * .Width)
            .Top = Application.Top + (0.5 * Application.Height) - (0.5 * .Height)
            .Show
        End With
    Application.ScreenUpdating = True
End Sub
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Sort by date Sort by votes
I tested it numerous times with Excel 2013 and didn't encounter any problems. Does it help if you set the properties for the userform in either the Initialize or Activate event?
 
Upvote 0
I never thought about the Activate event, but when I changed the initialize event to Activate event the program doesn't freeze after 20 tries. Are there other benefits to using the Activate event with a userform?
 
Upvote 0
Actually, I meant that you should try setting the properties (the ones that you posted) in the Initialize or Activate event (although I think I would use the Initialize event to set properties). So basically move your code from StartNew to Initialze, along with your other code. So did you move everything from Initialize to Active, including the code that you posted?
 
Upvote 0
I just changed as below

Code: 
Private Sub UserForm_Activate()    'Initialize()
    MultiPage2.Value = 0
    Me.txt_po.Value = Sheets("details").Range("nextpo").Value
It is working fine, is there some reason this would not work? I did not change the code I originally posted.
 
Upvote 0
That's interesting... I don't see anything there that should be a problem... but you did say that you have a large number of rows with code in the Initialize event... so maybe there might be something in those other lines... generally, though, the Initialize event is used to set properties... for the Activate event, the userform needs to be visible.
 
Upvote 0
Here is my original code for the Initialize event for the userform, if you see anything that would make it hang up I would be interested.

Code: 
Private Sub UserForm_Initialize()
    MultiPage2.Value = 0
    Me.txt_po.Value = Sheets("details").Range("nextpo").Value
        
    Dim xstate As Range
    Dim xowner As Range
    Dim xowner1 As Range
    Dim xowner2 As Range
    Dim xowner3 As Range
    Dim xowner4 As Range
    Dim xlogger As Range
    Dim xcounty As Range
    Dim xlogger1 As Range
    Dim xlogger2 As Range
    Dim xlogger3 As Range
    Dim xlogger4 As Range
        
    Dim WS As Worksheet
    Set WS = Worksheets("Lookups")
    
    For Each xstate In WS.Range("stateTable")
        With Me.cbo_state
            .AddItem xstate.Value
        End With
    Next xstate
    
    For Each xcounty In WS.Range("countyTable[county]")
        With Me.cbo_county
            .AddItem xcounty.Value
        End With
    Next xcounty
    
'Delivery Point 1
    For Each dp1 In WS.Range("deliveryTable[Delivery Point]")
        With Me.cbo_dp1
            .AddItem dp1.Value
        End With
    Next dp1
    
    For Each sg1 In WS.Range("speciegradeTable")
        With Me.cbo_sg1
            .AddItem sg1
        End With
    Next sg1
     
'Delivery Point 2
    For Each dp2 In WS.Range("deliveryTable[Delivery Point]")
        With Me.cbo_dp2
            .AddItem dp2.Value
        End With
    Next dp2
    
    For Each sg2 In WS.Range("speciegradeTable")
        With Me.cbo_sg2
            .AddItem sg2
        End With
    Next sg2
    
'Delivery Point 3
    For Each dp3 In WS.Range("deliveryTable[Delivery Point]")
        With Me.cbo_dp3
            .AddItem dp3.Value
        End With
    Next dp3
    
    For Each sg3 In WS.Range("speciegradeTable")
        With Me.cbo_sg3
            .AddItem sg3
        End With
    Next sg3
    
'Delivery Point 4
    For Each dp4 In WS.Range("deliveryTable[Delivery Point]")
        With Me.cbo_dp4
            .AddItem dp4.Value
        End With
    Next dp4
    
    For Each sg4 In WS.Range("speciegradeTable")
        With Me.cbo_sg4
            .AddItem sg4
        End With
    Next sg4
    
'Delivery Point 5
    For Each dp5 In WS.Range("deliveryTable[Delivery Point]")
        With Me.cbo_dp5
            .AddItem dp5.Value
        End With
    Next dp5
    
    For Each sg5 In WS.Range("deliveryTable[Delivery Point]")
        With Me.cbo_sg5
            .AddItem sg5
        End With
    Next sg5
    
'Delivery Point 6
    For Each dp6 In WS.Range("deliveryTable[Delivery Point]")
        With Me.cbo_dp6
            .AddItem dp6.Value
        End With
    Next dp6
    
    For Each sg6 In WS.Range("speciegradeTable")
        With Me.cbo_sg6
            .AddItem sg6
        End With
    Next sg6
    
'Forester
    For Each forester In WS.Range("foresterTable[Forester]")
        With Me.cbo_forester
            .AddItem forester.Value
        End With
    Next forester
    
'Purchaser
    For Each purchaser In WS.Range("purchTable[Purchaser]")
        With Me.cbo_purchaser
            .AddItem purchaser.Value
        End With
    Next purchaser
    
'Haul Cost Paid By
    For Each haulcost In WS.Range("haulcostTable[From]")
        With Me.cbo_haulcost
            .AddItem haulcost.Value
        End With
    Next haulcost
    
'POPULATE OWNERS TABLE
    Set WS = Worksheets("owners")
    For Each xowner In WS.Range("ownersTable[name]")
        With Me.cbo_O_owner
           .AddItem xowner.Value
        End With
    Next xowner
      
    MultiPage2.Page1.Visible = False

'POPULATE OWNERS 1 TABLE
    Set WS = Worksheets("owners")
    For Each xowner1 In WS.Range("ownersTable[name]")
        With Me.cbo_owner1
           .AddItem xowner1.Value
        End With
    Next xowner1

'POPULATE OWNERS 2 TABLE
    For Each xowner2 In WS.Range("ownersTable[name]")
        With Me.cbo_owner2
           .AddItem xowner2.Value
        End With
    Next xowner2

'POPULATE OWNERS 3 TABLE
    For Each xowner3 In WS.Range("ownersTable[name]")
        With Me.cbo_owner3
           .AddItem xowner3.Value
        End With
    Next xowner3

'POPULATE OWNERS 4 TABLE
    For Each xowner4 In WS.Range("ownersTable[name]")
        With Me.cbo_owner4
           .AddItem xowner4.Value
        End With
    Next xowner4

'POPULATE LOGGERS TABLE
    Set WS = Worksheets("loggers")
    For Each xlogger In WS.Range("loggersTable[name]")
        With Me.cbo_L_logger
            .AddItem xlogger.Value
        End With
    Next xlogger
      
    MultiPage2.Page2.Visible = False

'POPULATE LOGGERS/HAULERS 1 TABLE
    Set WS = Worksheets("loggers")
    For Each xlogger1 In WS.Range("loggersTable[name]")
        With Me.cbo_logger1
           .AddItem xlogger1.Value
        End With
    Next xlogger1

'POPULATE LOGGERS/HAULERS 2 TABLE
    Set WS = Worksheets("loggers")
    For Each xlogger2 In WS.Range("loggersTable[name]")
        With Me.cbo_logger2
           .AddItem xlogger2.Value
        End With
    Next xlogger2

'POPULATE LOGGERS/HAULERS 3 TABLE
    Set WS = Worksheets("loggers")
    For Each xlogger3 In WS.Range("loggersTable[name]")
        With Me.cbo_logger3
           .AddItem xlogger3.Value
        End With
    Next xlogger3

'POPULATE LOGGERS/HAULERS 4 TABLE
    Set WS = Worksheets("loggers")
    For Each xlogger4 In WS.Range("loggersTable[name]")
        With Me.cbo_logger4
           .AddItem xlogger4.Value
        End With
    Next xlogger4

'POPULATE WLC MATRIX
    Me.txt_a_r1c1_newWLC.Value = Worksheets("defaultmatrix").Range("C9")
    Me.txt_a_r1c2_newWLC.Value = Worksheets("defaultmatrix").Range("D9")
    Me.txt_a_r1c3_newWLC.Value = Worksheets("defaultmatrix").Range("E9")
    Me.txt_a_r1c4_newWLC.Value = Worksheets("defaultmatrix").Range("F9")
    Me.txt_a_r1c5_newWLC.Value = Worksheets("defaultmatrix").Range("G9")
    Me.txt_a_r1c6_newWLC.Value = Worksheets("defaultmatrix").Range("H9")
    Me.txt_a_r1c7_newWLC.Value = Worksheets("defaultmatrix").Range("I9")
    Me.txt_a_r1c8_newWLC.Value = Worksheets("defaultmatrix").Range("J9")
    
    Me.txt_a_r2c1_newWLC.Value = Worksheets("defaultmatrix").Range("C10")
    Me.txt_a_r2c2_newWLC.Value = Worksheets("defaultmatrix").Range("D10")
    Me.txt_a_r2c3_newWLC.Value = Worksheets("defaultmatrix").Range("E10")
    Me.txt_a_r2c4_newWLC.Value = Worksheets("defaultmatrix").Range("F10")
    Me.txt_a_r2c5_newWLC.Value = Worksheets("defaultmatrix").Range("G10")
    Me.txt_a_r2c6_newWLC.Value = Worksheets("defaultmatrix").Range("H10")
    Me.txt_a_r2c7_newWLC.Value = Worksheets("defaultmatrix").Range("I10")
    Me.txt_a_r2c8_newWLC.Value = Worksheets("defaultmatrix").Range("J10")
    
    Me.txt_a_r3c1_newWLC.Value = Worksheets("defaultmatrix").Range("C11")
    Me.txt_a_r3c2_newWLC.Value = Worksheets("defaultmatrix").Range("D11")
    Me.txt_a_r3c3_newWLC.Value = Worksheets("defaultmatrix").Range("E11")
    Me.txt_a_r3c4_newWLC.Value = Worksheets("defaultmatrix").Range("F11")
    Me.txt_a_r3c5_newWLC.Value = Worksheets("defaultmatrix").Range("G11")
    Me.txt_a_r3c6_newWLC.Value = Worksheets("defaultmatrix").Range("H11")
    Me.txt_a_r3c7_newWLC.Value = Worksheets("defaultmatrix").Range("I11")
    Me.txt_a_r3c8_newWLC.Value = Worksheets("defaultmatrix").Range("J11")
    
    Me.txt_a_r4c1_newWLC.Value = Worksheets("defaultmatrix").Range("C12")
    Me.txt_a_r4c2_newWLC.Value = Worksheets("defaultmatrix").Range("D12")
    Me.txt_a_r4c3_newWLC.Value = Worksheets("defaultmatrix").Range("E12")
    Me.txt_a_r4c4_newWLC.Value = Worksheets("defaultmatrix").Range("F12")
    Me.txt_a_r4c5_newWLC.Value = Worksheets("defaultmatrix").Range("G12")
    Me.txt_a_r4c6_newWLC.Value = Worksheets("defaultmatrix").Range("H12")
    Me.txt_a_r4c7_newWLC.Value = Worksheets("defaultmatrix").Range("I12")
    Me.txt_a_r4c8_newWLC.Value = Worksheets("defaultmatrix").Range("J12")
    
    Me.txt_a_r5c1_newWLC.Value = Worksheets("defaultmatrix").Range("C13")
    Me.txt_a_r5c2_newWLC.Value = Worksheets("defaultmatrix").Range("D13")
    Me.txt_a_r5c3_newWLC.Value = Worksheets("defaultmatrix").Range("E13")
    Me.txt_a_r5c4_newWLC.Value = Worksheets("defaultmatrix").Range("F13")
    Me.txt_a_r5c5_newWLC.Value = Worksheets("defaultmatrix").Range("G13")
    Me.txt_a_r5c6_newWLC.Value = Worksheets("defaultmatrix").Range("H13")
    Me.txt_a_r5c7_newWLC.Value = Worksheets("defaultmatrix").Range("I13")
    Me.txt_a_r5c8_newWLC.Value = Worksheets("defaultmatrix").Range("J13")
    
    Me.txt_a_r6c1_newWLC.Value = Worksheets("defaultmatrix").Range("C15")
    Me.txt_a_r6c2_newWLC.Value = Worksheets("defaultmatrix").Range("D15")
    Me.txt_a_r6c3_newWLC.Value = Worksheets("defaultmatrix").Range("E15")
    Me.txt_a_r6c4_newWLC.Value = Worksheets("defaultmatrix").Range("F15")
    Me.txt_a_r6c5_newWLC.Value = Worksheets("defaultmatrix").Range("G15")
    Me.txt_a_r6c6_newWLC.Value = Worksheets("defaultmatrix").Range("H15")
    Me.txt_a_r6c7_newWLC.Value = Worksheets("defaultmatrix").Range("I15")
    Me.txt_a_r6c8_newWLC.Value = Worksheets("defaultmatrix").Range("J15")
    
    Me.txt_a_r7c1_newWLC.Value = Worksheets("defaultmatrix").Range("C16")
    Me.txt_a_r7c2_newWLC.Value = Worksheets("defaultmatrix").Range("D16")
    Me.txt_a_r7c3_newWLC.Value = Worksheets("defaultmatrix").Range("E16")
    Me.txt_a_r7c4_newWLC.Value = Worksheets("defaultmatrix").Range("F16")
    Me.txt_a_r7c5_newWLC.Value = Worksheets("defaultmatrix").Range("G16")
    Me.txt_a_r7c6_newWLC.Value = Worksheets("defaultmatrix").Range("H16")
    Me.txt_a_r7c7_newWLC.Value = Worksheets("defaultmatrix").Range("I16")
    Me.txt_a_r7c8_newWLC.Value = Worksheets("defaultmatrix").Range("J16")

    Me.txt_b_r1c1_newWLC.Value = Worksheets("defaultmatrix").Range("C25")
    Me.txt_b_r1c2_newWLC.Value = Worksheets("defaultmatrix").Range("D25")
    Me.txt_b_r1c3_newWLC.Value = Worksheets("defaultmatrix").Range("E25")
    Me.txt_b_r1c4_newWLC.Value = Worksheets("defaultmatrix").Range("F25")
    Me.txt_b_r1c5_newWLC.Value = Worksheets("defaultmatrix").Range("G25")
    Me.txt_b_r1c6_newWLC.Value = Worksheets("defaultmatrix").Range("H25")

    Me.txt_b_r2c1_newWLC.Value = Worksheets("defaultmatrix").Range("C26")
    Me.txt_b_r2c2_newWLC.Value = Worksheets("defaultmatrix").Range("D26")
    Me.txt_b_r2c3_newWLC.Value = Worksheets("defaultmatrix").Range("E26")
    Me.txt_b_r2c4_newWLC.Value = Worksheets("defaultmatrix").Range("F26")
    Me.txt_b_r2c5_newWLC.Value = Worksheets("defaultmatrix").Range("G26")
    Me.txt_b_r2c6_newWLC.Value = Worksheets("defaultmatrix").Range("H26")

    Me.txt_b_r3c1_newWLC.Value = Worksheets("defaultmatrix").Range("C27")
    Me.txt_b_r3c2_newWLC.Value = Worksheets("defaultmatrix").Range("D27")
    Me.txt_b_r3c3_newWLC.Value = Worksheets("defaultmatrix").Range("E27")
    Me.txt_b_r3c4_newWLC.Value = Worksheets("defaultmatrix").Range("F27")
    Me.txt_b_r3c5_newWLC.Value = Worksheets("defaultmatrix").Range("G27")
    Me.txt_b_r3c6_newWLC.Value = Worksheets("defaultmatrix").Range("H27")

    Me.txt_b_r4c1_newWLC.Value = Worksheets("defaultmatrix").Range("C28")
    Me.txt_b_r4c2_newWLC.Value = Worksheets("defaultmatrix").Range("D28")
    Me.txt_b_r4c3_newWLC.Value = Worksheets("defaultmatrix").Range("E28")
    Me.txt_b_r4c4_newWLC.Value = Worksheets("defaultmatrix").Range("F28")
    Me.txt_b_r4c5_newWLC.Value = Worksheets("defaultmatrix").Range("G28")
    Me.txt_b_r4c6_newWLC.Value = Worksheets("defaultmatrix").Range("H28")

    Me.txt_b_r5c1_newWLC.Value = Worksheets("defaultmatrix").Range("C30")
    Me.txt_b_r5c2_newWLC.Value = Worksheets("defaultmatrix").Range("D30")
    Me.txt_b_r5c3_newWLC.Value = Worksheets("defaultmatrix").Range("E30")
    Me.txt_b_r5c4_newWLC.Value = Worksheets("defaultmatrix").Range("F30")
    Me.txt_b_r5c5_newWLC.Value = Worksheets("defaultmatrix").Range("G30")
    Me.txt_b_r5c6_newWLC.Value = Worksheets("defaultmatrix").Range("H30")

'POPULATE TLC MATRIX
    Me.txt_a_r1c1_newTLC.Value = Worksheets("defaultmatrix").Range("M9")
    Me.txt_a_r1c2_newTLC.Value = Worksheets("defaultmatrix").Range("N9")
    Me.txt_a_r1c3_newTLC.Value = Worksheets("defaultmatrix").Range("O9")
    Me.txt_a_r1c4_newTLC.Value = Worksheets("defaultmatrix").Range("P9")
    Me.txt_a_r1c5_newTLC.Value = Worksheets("defaultmatrix").Range("Q9")
    Me.txt_a_r1c6_newTLC.Value = Worksheets("defaultmatrix").Range("R9")

    Me.txt_a_r2c1_newTLC.Value = Worksheets("defaultmatrix").Range("M10")
    Me.txt_a_r2c2_newTLC.Value = Worksheets("defaultmatrix").Range("N10")
    Me.txt_a_r2c3_newTLC.Value = Worksheets("defaultmatrix").Range("O10")
    Me.txt_a_r2c4_newTLC.Value = Worksheets("defaultmatrix").Range("P10")
    Me.txt_a_r2c5_newTLC.Value = Worksheets("defaultmatrix").Range("Q10")
    Me.txt_a_r2c6_newTLC.Value = Worksheets("defaultmatrix").Range("R10")

    Me.txt_a_r3c1_newTLC.Value = Worksheets("defaultmatrix").Range("M11")
    Me.txt_a_r3c2_newTLC.Value = Worksheets("defaultmatrix").Range("N11")
    Me.txt_a_r3c3_newTLC.Value = Worksheets("defaultmatrix").Range("O11")
    Me.txt_a_r3c4_newTLC.Value = Worksheets("defaultmatrix").Range("P11")
    Me.txt_a_r3c5_newTLC.Value = Worksheets("defaultmatrix").Range("Q11")
    Me.txt_a_r3c6_newTLC.Value = Worksheets("defaultmatrix").Range("R11")

    Me.txt_a_r4c1_newTLC.Value = Worksheets("defaultmatrix").Range("M12")
    Me.txt_a_r4c2_newTLC.Value = Worksheets("defaultmatrix").Range("N12")
    Me.txt_a_r4c3_newTLC.Value = Worksheets("defaultmatrix").Range("O12")
    Me.txt_a_r4c4_newTLC.Value = Worksheets("defaultmatrix").Range("P12")
    Me.txt_a_r4c5_newTLC.Value = Worksheets("defaultmatrix").Range("Q12")
    Me.txt_a_r4c6_newTLC.Value = Worksheets("defaultmatrix").Range("R12")

    Me.txt_a_r5c1_newTLC.Value = Worksheets("defaultmatrix").Range("M13")
    Me.txt_a_r5c2_newTLC.Value = Worksheets("defaultmatrix").Range("N13")
    Me.txt_a_r5c3_newTLC.Value = Worksheets("defaultmatrix").Range("O13")
    Me.txt_a_r5c4_newTLC.Value = Worksheets("defaultmatrix").Range("P13")
    Me.txt_a_r5c5_newTLC.Value = Worksheets("defaultmatrix").Range("Q13")
    Me.txt_a_r5c6_newTLC.Value = Worksheets("defaultmatrix").Range("R13")

    Me.txt_a_r6c1_newTLC.Value = Worksheets("defaultmatrix").Range("M14")
    Me.txt_a_r6c2_newTLC.Value = Worksheets("defaultmatrix").Range("N14")
    Me.txt_a_r6c3_newTLC.Value = Worksheets("defaultmatrix").Range("O14")
 
    Me.txt_a_r7c1_newTLC.Value = Worksheets("defaultmatrix").Range("M16")
    Me.txt_a_r7c2_newTLC.Value = Worksheets("defaultmatrix").Range("N16")
    Me.txt_a_r7c3_newTLC.Value = Worksheets("defaultmatrix").Range("O16")
    Me.txt_a_r7c4_newTLC.Value = Worksheets("defaultmatrix").Range("P16")
    Me.txt_a_r7c5_newTLC.Value = Worksheets("defaultmatrix").Range("Q16")
    Me.txt_a_r7c6_newTLC.Value = Worksheets("defaultmatrix").Range("R16")

    Me.txt_b_r1c1_newTLC.Value = Worksheets("defaultmatrix").Range("M25")
    Me.txt_b_r1c2_newTLC.Value = Worksheets("defaultmatrix").Range("N25")
    Me.txt_b_r1c3_newTLC.Value = Worksheets("defaultmatrix").Range("O25")
    Me.txt_b_r1c4_newTLC.Value = Worksheets("defaultmatrix").Range("P25")
    Me.txt_b_r1c5_newTLC.Value = Worksheets("defaultmatrix").Range("Q25")
    Me.txt_b_r1c6_newTLC.Value = Worksheets("defaultmatrix").Range("R25")

    Me.txt_b_r2c1_newTLC.Value = Worksheets("defaultmatrix").Range("M26")
    Me.txt_b_r2c2_newTLC.Value = Worksheets("defaultmatrix").Range("N26")
    Me.txt_b_r2c3_newTLC.Value = Worksheets("defaultmatrix").Range("O26")
    Me.txt_b_r2c4_newTLC.Value = Worksheets("defaultmatrix").Range("P26")
    Me.txt_b_r2c5_newTLC.Value = Worksheets("defaultmatrix").Range("Q26")
    Me.txt_b_r2c6_newTLC.Value = Worksheets("defaultmatrix").Range("R26")

    Me.txt_b_r3c1_newTLC.Value = Worksheets("defaultmatrix").Range("M27")
    Me.txt_b_r3c2_newTLC.Value = Worksheets("defaultmatrix").Range("N27")
    Me.txt_b_r3c3_newTLC.Value = Worksheets("defaultmatrix").Range("O27")
    Me.txt_b_r3c4_newTLC.Value = Worksheets("defaultmatrix").Range("P27")
    Me.txt_b_r3c5_newTLC.Value = Worksheets("defaultmatrix").Range("Q27")
    Me.txt_b_r3c6_newTLC.Value = Worksheets("defaultmatrix").Range("R27")

    Me.txt_b_r4c1_newTLC.Value = Worksheets("defaultmatrix").Range("M29")
    Me.txt_b_r4c2_newTLC.Value = Worksheets("defaultmatrix").Range("N29")
    Me.txt_b_r4c3_newTLC.Value = Worksheets("defaultmatrix").Range("O29")
    Me.txt_b_r4c4_newTLC.Value = Worksheets("defaultmatrix").Range("P29")
    Me.txt_b_r4c5_newTLC.Value = Worksheets("defaultmatrix").Range("Q29")
    Me.txt_b_r4c6_newTLC.Value = Worksheets("defaultmatrix").Range("R29")

'POPULATE WAR MATRIX
    Me.txt_a_r1c1_newWAR.Value = Worksheets("defaultmatrix").Range("U9")
    Me.txt_a_r1c2_newWAR.Value = Worksheets("defaultmatrix").Range("V9")
    Me.txt_a_r1c3_newWAR.Value = Worksheets("defaultmatrix").Range("W9")
    Me.txt_a_r1c4_newWAR.Value = Worksheets("defaultmatrix").Range("X9")
    Me.txt_a_r1c5_newWAR.Value = Worksheets("defaultmatrix").Range("Y9")
    Me.txt_a_r1c6_newWAR.Value = Worksheets("defaultmatrix").Range("Z9")

    Me.txt_a_r2c1_newWAR.Value = Worksheets("defaultmatrix").Range("U10")
    Me.txt_a_r2c2_newWAR.Value = Worksheets("defaultmatrix").Range("V10")
    Me.txt_a_r2c3_newWAR.Value = Worksheets("defaultmatrix").Range("W10")
    Me.txt_a_r2c4_newWAR.Value = Worksheets("defaultmatrix").Range("X10")
    Me.txt_a_r2c5_newWAR.Value = Worksheets("defaultmatrix").Range("Y10")
    Me.txt_a_r2c6_newWAR.Value = Worksheets("defaultmatrix").Range("Z10")

    Me.txt_a_r3c1_newWAR.Value = Worksheets("defaultmatrix").Range("U11")
    Me.txt_a_r3c2_newWAR.Value = Worksheets("defaultmatrix").Range("V11")
    Me.txt_a_r3c3_newWAR.Value = Worksheets("defaultmatrix").Range("W11")
    Me.txt_a_r3c4_newWAR.Value = Worksheets("defaultmatrix").Range("X11")
    Me.txt_a_r3c5_newWAR.Value = Worksheets("defaultmatrix").Range("Y11")
    Me.txt_a_r3c6_newWAR.Value = Worksheets("defaultmatrix").Range("Z11")

    Me.txt_a_r4c1_newWAR.Value = Worksheets("defaultmatrix").Range("U12")
    Me.txt_a_r4c2_newWAR.Value = Worksheets("defaultmatrix").Range("V12")
    Me.txt_a_r4c3_newWAR.Value = Worksheets("defaultmatrix").Range("W12")
    Me.txt_a_r4c4_newWAR.Value = Worksheets("defaultmatrix").Range("X12")
    Me.txt_a_r4c5_newWAR.Value = Worksheets("defaultmatrix").Range("Y12")
    Me.txt_a_r4c6_newWAR.Value = Worksheets("defaultmatrix").Range("Z12")

    Me.txt_a_r5c1_newWAR.Value = Worksheets("defaultmatrix").Range("U13")
    Me.txt_a_r5c2_newWAR.Value = Worksheets("defaultmatrix").Range("V13")
    Me.txt_a_r5c3_newWAR.Value = Worksheets("defaultmatrix").Range("W13")
    Me.txt_a_r5c4_newWAR.Value = Worksheets("defaultmatrix").Range("X13")
    Me.txt_a_r5c5_newWAR.Value = Worksheets("defaultmatrix").Range("Y13")
    Me.txt_a_r5c6_newWAR.Value = Worksheets("defaultmatrix").Range("Z13")

    Me.txt_a_r6c1_newWAR.Value = Worksheets("defaultmatrix").Range("U14")
    Me.txt_a_r6c2_newWAR.Value = Worksheets("defaultmatrix").Range("V14")
    Me.txt_a_r6c3_newWAR.Value = Worksheets("defaultmatrix").Range("W14")
    Me.txt_a_r6c4_newWAR.Value = Worksheets("defaultmatrix").Range("X14")
    Me.txt_a_r6c5_newWAR.Value = Worksheets("defaultmatrix").Range("Y14")
    Me.txt_a_r6c6_newWAR.Value = Worksheets("defaultmatrix").Range("Z14")

    Me.txt_a_r6c1_newWAR.Value = Worksheets("defaultmatrix").Range("U14")
    Me.txt_a_r6c2_newWAR.Value = Worksheets("defaultmatrix").Range("V14")
    Me.txt_a_r6c3_newWAR.Value = Worksheets("defaultmatrix").Range("W14")
    Me.txt_a_r6c4_newWAR.Value = Worksheets("defaultmatrix").Range("X14")
    Me.txt_a_r6c5_newWAR.Value = Worksheets("defaultmatrix").Range("Y14")
    Me.txt_a_r6c6_newWAR.Value = Worksheets("defaultmatrix").Range("Z14")

    Me.txt_a_r7c1_newWAR.Value = Worksheets("defaultmatrix").Range("U16")
    Me.txt_a_r7c2_newWAR.Value = Worksheets("defaultmatrix").Range("V16")
    Me.txt_a_r7c3_newWAR.Value = Worksheets("defaultmatrix").Range("W16")
    Me.txt_a_r7c4_newWAR.Value = Worksheets("defaultmatrix").Range("X16")
    Me.txt_a_r7c5_newWAR.Value = Worksheets("defaultmatrix").Range("Y16")
    Me.txt_a_r7c6_newWAR.Value = Worksheets("defaultmatrix").Range("Z16")

    Me.txt_b_r1c1_newWAR.Value = Worksheets("defaultmatrix").Range("U25")
    Me.txt_b_r1c2_newWAR.Value = Worksheets("defaultmatrix").Range("V25")
    Me.txt_b_r1c3_newWAR.Value = Worksheets("defaultmatrix").Range("W25")
    Me.txt_b_r1c4_newWAR.Value = Worksheets("defaultmatrix").Range("X25")
    Me.txt_b_r1c5_newWAR.Value = Worksheets("defaultmatrix").Range("Y25")
    Me.txt_b_r1c6_newWAR.Value = Worksheets("defaultmatrix").Range("Z25")

    Me.txt_b_r2c1_newWAR.Value = Worksheets("defaultmatrix").Range("U26")
    Me.txt_b_r2c2_newWAR.Value = Worksheets("defaultmatrix").Range("V26")
    Me.txt_b_r2c3_newWAR.Value = Worksheets("defaultmatrix").Range("W26")
    Me.txt_b_r2c4_newWAR.Value = Worksheets("defaultmatrix").Range("X26")
    Me.txt_b_r2c5_newWAR.Value = Worksheets("defaultmatrix").Range("Y26")
    Me.txt_b_r2c6_newWAR.Value = Worksheets("defaultmatrix").Range("Z26")

    Me.txt_b_r3c1_newWAR.Value = Worksheets("defaultmatrix").Range("U27")
    Me.txt_b_r3c2_newWAR.Value = Worksheets("defaultmatrix").Range("V27")
    Me.txt_b_r3c3_newWAR.Value = Worksheets("defaultmatrix").Range("W27")
    Me.txt_b_r3c4_newWAR.Value = Worksheets("defaultmatrix").Range("X27")
    Me.txt_b_r3c5_newWAR.Value = Worksheets("defaultmatrix").Range("Y27")
    Me.txt_b_r3c6_newWAR.Value = Worksheets("defaultmatrix").Range("Z27")

    Me.txt_b_r4c1_newWAR.Value = Worksheets("defaultmatrix").Range("U28")
    Me.txt_b_r4c2_newWAR.Value = Worksheets("defaultmatrix").Range("V28")
    Me.txt_b_r4c3_newWAR.Value = Worksheets("defaultmatrix").Range("W28")
    Me.txt_b_r4c4_newWAR.Value = Worksheets("defaultmatrix").Range("X28")
    Me.txt_b_r4c5_newWAR.Value = Worksheets("defaultmatrix").Range("Y28")
    Me.txt_b_r4c6_newWAR.Value = Worksheets("defaultmatrix").Range("Z28")

    Me.txt_b_r5c1_newWAR.Value = Worksheets("defaultmatrix").Range("U29")
    Me.txt_b_r5c2_newWAR.Value = Worksheets("defaultmatrix").Range("V29")
    Me.txt_b_r5c3_newWAR.Value = Worksheets("defaultmatrix").Range("W29")
    Me.txt_b_r5c4_newWAR.Value = Worksheets("defaultmatrix").Range("X29")
    Me.txt_b_r5c5_newWAR.Value = Worksheets("defaultmatrix").Range("Y29")
    Me.txt_b_r5c6_newWAR.Value = Worksheets("defaultmatrix").Range("Z29")

    Me.txt_b_r6c1_newWAR.Value = Worksheets("defaultmatrix").Range("U30")
    Me.txt_b_r6c2_newWAR.Value = Worksheets("defaultmatrix").Range("V30")
    Me.txt_b_r6c3_newWAR.Value = Worksheets("defaultmatrix").Range("W30")
    Me.txt_b_r6c4_newWAR.Value = Worksheets("defaultmatrix").Range("X30")
    Me.txt_b_r6c5_newWAR.Value = Worksheets("defaultmatrix").Range("Y30")
    Me.txt_b_r6c6_newWAR.Value = Worksheets("defaultmatrix").Range("Z30")

    Me.txt_b_r7c1_newWAR.Value = Worksheets("defaultmatrix").Range("U32")
    Me.txt_b_r7c2_newWAR.Value = Worksheets("defaultmatrix").Range("V32")
    Me.txt_b_r7c3_newWAR.Value = Worksheets("defaultmatrix").Range("W32")
    Me.txt_b_r7c4_newWAR.Value = Worksheets("defaultmatrix").Range("X32")
    Me.txt_b_r7c5_newWAR.Value = Worksheets("defaultmatrix").Range("Y32")
    Me.txt_b_r7c6_newWAR.Value = Worksheets("defaultmatrix").Range("Z32")

'POPULATE RAN MATRIX
    Me.txt_a_r1c1_newRAN.Value = Worksheets("defaultmatrix").Range("AC9")
    Me.txt_a_r1c2_newRAN.Value = Worksheets("defaultmatrix").Range("AD9")
    Me.txt_a_r1c3_newRAN.Value = Worksheets("defaultmatrix").Range("AE9")
    Me.txt_a_r1c4_newRAN.Value = Worksheets("defaultmatrix").Range("AF9")
    Me.txt_a_r1c5_newRAN.Value = Worksheets("defaultmatrix").Range("AG9")
    Me.txt_a_r1c6_newRAN.Value = Worksheets("defaultmatrix").Range("AH9")
    Me.txt_a_r1c7_newRAN.Value = Worksheets("defaultmatrix").Range("AI9")

    Me.txt_a_r2c1_newRAN.Value = Worksheets("defaultmatrix").Range("AC10")
    Me.txt_a_r2c2_newRAN.Value = Worksheets("defaultmatrix").Range("AD10")
    Me.txt_a_r2c3_newRAN.Value = Worksheets("defaultmatrix").Range("AE10")
    Me.txt_a_r2c4_newRAN.Value = Worksheets("defaultmatrix").Range("AF10")
    Me.txt_a_r2c5_newRAN.Value = Worksheets("defaultmatrix").Range("AG10")
    Me.txt_a_r2c6_newRAN.Value = Worksheets("defaultmatrix").Range("AH10")
    Me.txt_a_r2c7_newRAN.Value = Worksheets("defaultmatrix").Range("AI10")

    Me.txt_a_r3c1_newRAN.Value = Worksheets("defaultmatrix").Range("AC11")
    Me.txt_a_r3c2_newRAN.Value = Worksheets("defaultmatrix").Range("AD11")
    Me.txt_a_r3c3_newRAN.Value = Worksheets("defaultmatrix").Range("AE11")
    Me.txt_a_r3c4_newRAN.Value = Worksheets("defaultmatrix").Range("AF11")
    Me.txt_a_r3c5_newRAN.Value = Worksheets("defaultmatrix").Range("AG11")
    Me.txt_a_r3c6_newRAN.Value = Worksheets("defaultmatrix").Range("AH11")
    Me.txt_a_r3c7_newRAN.Value = Worksheets("defaultmatrix").Range("AI11")

    Me.txt_a_r4c1_newRAN.Value = Worksheets("defaultmatrix").Range("AC12")
    Me.txt_a_r4c2_newRAN.Value = Worksheets("defaultmatrix").Range("AD12")
    Me.txt_a_r4c3_newRAN.Value = Worksheets("defaultmatrix").Range("AE12")
    Me.txt_a_r4c4_newRAN.Value = Worksheets("defaultmatrix").Range("AF12")
    Me.txt_a_r4c5_newRAN.Value = Worksheets("defaultmatrix").Range("AG12")
    Me.txt_a_r4c6_newRAN.Value = Worksheets("defaultmatrix").Range("AH12")
    Me.txt_a_r4c7_newRAN.Value = Worksheets("defaultmatrix").Range("AI12")

    Me.txt_a_r5c1_newRAN.Value = Worksheets("defaultmatrix").Range("AC13")
    Me.txt_a_r5c2_newRAN.Value = Worksheets("defaultmatrix").Range("AD13")
    Me.txt_a_r5c3_newRAN.Value = Worksheets("defaultmatrix").Range("AE13")
    Me.txt_a_r5c4_newRAN.Value = Worksheets("defaultmatrix").Range("AF13")
    Me.txt_a_r5c5_newRAN.Value = Worksheets("defaultmatrix").Range("AG13")
    Me.txt_a_r5c6_newRAN.Value = Worksheets("defaultmatrix").Range("AH13")
    Me.txt_a_r5c7_newRAN.Value = Worksheets("defaultmatrix").Range("AI13")

    Me.txt_a_r6c1_newRAN.Value = Worksheets("defaultmatrix").Range("AC14")
    Me.txt_a_r6c2_newRAN.Value = Worksheets("defaultmatrix").Range("AD14")
    Me.txt_a_r6c3_newRAN.Value = Worksheets("defaultmatrix").Range("AE14")
    Me.txt_a_r6c4_newRAN.Value = Worksheets("defaultmatrix").Range("AF14")
    Me.txt_a_r6c5_newRAN.Value = Worksheets("defaultmatrix").Range("AG14")
    Me.txt_a_r6c6_newRAN.Value = Worksheets("defaultmatrix").Range("AH14")
    Me.txt_a_r6c7_newRAN.Value = Worksheets("defaultmatrix").Range("AI14")

    Me.txt_a_r7c1_newRAN.Value = Worksheets("defaultmatrix").Range("AC15")
    Me.txt_a_r7c2_newRAN.Value = Worksheets("defaultmatrix").Range("AD15")
    Me.txt_a_r7c3_newRAN.Value = Worksheets("defaultmatrix").Range("AE15")
    Me.txt_a_r7c4_newRAN.Value = Worksheets("defaultmatrix").Range("AF15")
    Me.txt_a_r7c5_newRAN.Value = Worksheets("defaultmatrix").Range("AG15")
    Me.txt_a_r7c6_newRAN.Value = Worksheets("defaultmatrix").Range("AH15")
    Me.txt_a_r7c7_newRAN.Value = Worksheets("defaultmatrix").Range("AI15")

'FORMATTING MATRIX BOXES
    Me.txt_a_r1c1_newWLC.Value = Format(txt_a_r1c1_newWLC.Value, "###")
    Me.txt_a_r1c2_newWLC.Value = Format(txt_a_r1c2_newWLC.Value, "###")
    Me.txt_a_r1c3_newWLC.Value = Format(txt_a_r1c3_newWLC.Value, "###")
    Me.txt_a_r1c4_newWLC.Value = Format(txt_a_r1c4_newWLC.Value, "###")
    Me.txt_a_r1c5_newWLC.Value = Format(txt_a_r1c5_newWLC.Value, "###")
    Me.txt_a_r1c6_newWLC.Value = Format(txt_a_r1c6_newWLC.Value, "###")
    Me.txt_a_r1c7_newWLC.Value = Format(txt_a_r1c7_newWLC.Value, "###")
    Me.txt_a_r1c8_newWLC.Value = Format(txt_a_r1c8_newWLC.Value, "###")

    Me.txt_a_r2c1_newWLC.Value = Format(txt_a_r2c1_newWLC.Value, "###")
    Me.txt_a_r2c2_newWLC.Value = Format(txt_a_r2c2_newWLC.Value, "###")
    Me.txt_a_r2c3_newWLC.Value = Format(txt_a_r2c3_newWLC.Value, "###")
    Me.txt_a_r2c4_newWLC.Value = Format(txt_a_r2c4_newWLC.Value, "###")
    Me.txt_a_r2c5_newWLC.Value = Format(txt_a_r2c5_newWLC.Value, "###")
    Me.txt_a_r2c6_newWLC.Value = Format(txt_a_r2c6_newWLC.Value, "###")
    Me.txt_a_r2c7_newWLC.Value = Format(txt_a_r2c7_newWLC.Value, "###")
    Me.txt_a_r2c8_newWLC.Value = Format(txt_a_r2c8_newWLC.Value, "###")

    Me.txt_a_r3c1_newWLC.Value = Format(txt_a_r3c1_newWLC.Value, "###")
    Me.txt_a_r3c2_newWLC.Value = Format(txt_a_r3c2_newWLC.Value, "###")
    Me.txt_a_r3c3_newWLC.Value = Format(txt_a_r3c3_newWLC.Value, "###")
    Me.txt_a_r3c4_newWLC.Value = Format(txt_a_r3c4_newWLC.Value, "###")
    Me.txt_a_r3c5_newWLC.Value = Format(txt_a_r3c5_newWLC.Value, "###")
    Me.txt_a_r3c6_newWLC.Value = Format(txt_a_r3c6_newWLC.Value, "###")
    Me.txt_a_r3c7_newWLC.Value = Format(txt_a_r3c7_newWLC.Value, "###")
    Me.txt_a_r3c8_newWLC.Value = Format(txt_a_r3c8_newWLC.Value, "###")

    Me.txt_a_r4c1_newWLC.Value = Format(txt_a_r4c1_newWLC.Value, "###")
    Me.txt_a_r4c2_newWLC.Value = Format(txt_a_r4c2_newWLC.Value, "###")
    Me.txt_a_r4c3_newWLC.Value = Format(txt_a_r4c3_newWLC.Value, "###")
    Me.txt_a_r4c4_newWLC.Value = Format(txt_a_r4c4_newWLC.Value, "###")
    Me.txt_a_r4c5_newWLC.Value = Format(txt_a_r4c5_newWLC.Value, "###")
    Me.txt_a_r4c6_newWLC.Value = Format(txt_a_r4c6_newWLC.Value, "###")
    Me.txt_a_r4c7_newWLC.Value = Format(txt_a_r4c7_newWLC.Value, "###")
    Me.txt_a_r4c8_newWLC.Value = Format(txt_a_r4c8_newWLC.Value, "###")

    Me.txt_a_r5c1_newWLC.Value = Format(txt_a_r5c1_newWLC.Value, "###")
    Me.txt_a_r5c2_newWLC.Value = Format(txt_a_r5c2_newWLC.Value, "###")
    Me.txt_a_r5c3_newWLC.Value = Format(txt_a_r5c3_newWLC.Value, "###")
    Me.txt_a_r5c4_newWLC.Value = Format(txt_a_r5c4_newWLC.Value, "###")
    Me.txt_a_r5c5_newWLC.Value = Format(txt_a_r5c5_newWLC.Value, "###")
    Me.txt_a_r5c6_newWLC.Value = Format(txt_a_r5c6_newWLC.Value, "###")
    Me.txt_a_r5c7_newWLC.Value = Format(txt_a_r5c7_newWLC.Value, "###")
    Me.txt_a_r5c8_newWLC.Value = Format(txt_a_r5c8_newWLC.Value, "###")

    Me.txt_a_r6c1_newWLC.Value = Format(txt_a_r6c1_newWLC.Value, "###")
    Me.txt_a_r6c2_newWLC.Value = Format(txt_a_r6c2_newWLC.Value, "###")
    Me.txt_a_r6c3_newWLC.Value = Format(txt_a_r6c3_newWLC.Value, "###")
    Me.txt_a_r6c4_newWLC.Value = Format(txt_a_r6c4_newWLC.Value, "###")
    Me.txt_a_r6c5_newWLC.Value = Format(txt_a_r6c5_newWLC.Value, "###")
    Me.txt_a_r6c6_newWLC.Value = Format(txt_a_r6c6_newWLC.Value, "###")
    Me.txt_a_r6c7_newWLC.Value = Format(txt_a_r6c7_newWLC.Value, "###")
    Me.txt_a_r6c8_newWLC.Value = Format(txt_a_r6c8_newWLC.Value, "###")

    Me.txt_a_r7c1_newWLC.Value = Format(txt_a_r7c1_newWLC.Value, "###")
    Me.txt_a_r7c2_newWLC.Value = Format(txt_a_r7c2_newWLC.Value, "###")
    Me.txt_a_r7c3_newWLC.Value = Format(txt_a_r7c3_newWLC.Value, "###")
    Me.txt_a_r7c4_newWLC.Value = Format(txt_a_r7c4_newWLC.Value, "###")
    Me.txt_a_r7c5_newWLC.Value = Format(txt_a_r7c5_newWLC.Value, "###")
    Me.txt_a_r7c6_newWLC.Value = Format(txt_a_r7c6_newWLC.Value, "###")
    Me.txt_a_r7c7_newWLC.Value = Format(txt_a_r7c7_newWLC.Value, "###")
    Me.txt_a_r7c8_newWLC.Value = Format(txt_a_r7c8_newWLC.Value, "###")

    Me.txt_b_r1c1_newWLC.Value = Format(txt_b_r1c1_newWLC.Value, "###")
    Me.txt_b_r1c2_newWLC.Value = Format(txt_b_r1c2_newWLC.Value, "###")
    Me.txt_b_r1c3_newWLC.Value = Format(txt_b_r1c3_newWLC.Value, "###")
    Me.txt_b_r1c4_newWLC.Value = Format(txt_b_r1c4_newWLC.Value, "###")
    Me.txt_b_r1c5_newWLC.Value = Format(txt_b_r1c5_newWLC.Value, "###")
    Me.txt_b_r1c6_newWLC.Value = Format(txt_b_r1c6_newWLC.Value, "###")

    Me.txt_b_r2c1_newWLC.Value = Format(txt_b_r2c1_newWLC.Value, "###")
    Me.txt_b_r2c2_newWLC.Value = Format(txt_b_r2c2_newWLC.Value, "###")
    Me.txt_b_r2c3_newWLC.Value = Format(txt_b_r2c3_newWLC.Value, "###")
    Me.txt_b_r2c4_newWLC.Value = Format(txt_b_r2c4_newWLC.Value, "###")
    Me.txt_b_r2c5_newWLC.Value = Format(txt_b_r2c5_newWLC.Value, "###")
    Me.txt_b_r2c6_newWLC.Value = Format(txt_b_r2c6_newWLC.Value, "###")

    Me.txt_b_r3c1_newWLC.Value = Format(txt_b_r3c1_newWLC.Value, "###")
    Me.txt_b_r3c2_newWLC.Value = Format(txt_b_r3c2_newWLC.Value, "###")
    Me.txt_b_r3c3_newWLC.Value = Format(txt_b_r3c3_newWLC.Value, "###")
    Me.txt_b_r3c4_newWLC.Value = Format(txt_b_r3c4_newWLC.Value, "###")
    Me.txt_b_r3c5_newWLC.Value = Format(txt_b_r3c5_newWLC.Value, "###")
    Me.txt_b_r3c6_newWLC.Value = Format(txt_b_r3c6_newWLC.Value, "###")

    Me.txt_b_r4c1_newWLC.Value = Format(txt_b_r4c1_newWLC.Value, "###")
    Me.txt_b_r4c2_newWLC.Value = Format(txt_b_r4c2_newWLC.Value, "###")
    Me.txt_b_r4c3_newWLC.Value = Format(txt_b_r4c3_newWLC.Value, "###")
    Me.txt_b_r4c4_newWLC.Value = Format(txt_b_r4c4_newWLC.Value, "###")
    Me.txt_b_r4c5_newWLC.Value = Format(txt_b_r4c5_newWLC.Value, "###")
    Me.txt_b_r4c6_newWLC.Value = Format(txt_b_r4c6_newWLC.Value, "###")

    Me.txt_b_r5c1_newWLC.Value = Format(txt_b_r5c1_newWLC.Value, "###")
    Me.txt_b_r5c2_newWLC.Value = Format(txt_b_r5c2_newWLC.Value, "###")
    Me.txt_b_r5c3_newWLC.Value = Format(txt_b_r5c3_newWLC.Value, "###")
    Me.txt_b_r5c4_newWLC.Value = Format(txt_b_r5c4_newWLC.Value, "###")
    Me.txt_b_r5c5_newWLC.Value = Format(txt_b_r5c5_newWLC.Value, "###")
    Me.txt_b_r5c6_newWLC.Value = Format(txt_b_r5c6_newWLC.Value, "###")

    Me.txt_a_r1c1_newTLC.Value = Format(txt_a_r1c1_newTLC.Value, "###")
    Me.txt_a_r1c2_newTLC.Value = Format(txt_a_r1c2_newTLC.Value, "###")
    Me.txt_a_r1c3_newTLC.Value = Format(txt_a_r1c3_newTLC.Value, "###")
    Me.txt_a_r1c4_newTLC.Value = Format(txt_a_r1c4_newTLC.Value, "###")
    Me.txt_a_r1c5_newTLC.Value = Format(txt_a_r1c5_newTLC.Value, "###")
    Me.txt_a_r1c6_newTLC.Value = Format(txt_a_r1c6_newTLC.Value, "###")

    Me.txt_a_r2c1_newTLC.Value = Format(txt_a_r2c1_newTLC.Value, "###")
    Me.txt_a_r2c2_newTLC.Value = Format(txt_a_r2c2_newTLC.Value, "###")
    Me.txt_a_r2c3_newTLC.Value = Format(txt_a_r2c3_newTLC.Value, "###")
    Me.txt_a_r2c4_newTLC.Value = Format(txt_a_r2c4_newTLC.Value, "###")
    Me.txt_a_r2c5_newTLC.Value = Format(txt_a_r2c5_newTLC.Value, "###")
    Me.txt_a_r2c6_newTLC.Value = Format(txt_a_r2c6_newTLC.Value, "###")

    Me.txt_a_r3c1_newTLC.Value = Format(txt_a_r3c1_newTLC.Value, "###")
    Me.txt_a_r3c2_newTLC.Value = Format(txt_a_r3c2_newTLC.Value, "###")
    Me.txt_a_r3c3_newTLC.Value = Format(txt_a_r3c3_newTLC.Value, "###")
    Me.txt_a_r3c4_newTLC.Value = Format(txt_a_r3c4_newTLC.Value, "###")
    Me.txt_a_r3c5_newTLC.Value = Format(txt_a_r3c5_newTLC.Value, "###")
    Me.txt_a_r3c6_newTLC.Value = Format(txt_a_r3c6_newTLC.Value, "###")

    Me.txt_a_r4c1_newTLC.Value = Format(txt_a_r4c1_newTLC.Value, "###")
    Me.txt_a_r4c2_newTLC.Value = Format(txt_a_r4c2_newTLC.Value, "###")
    Me.txt_a_r4c3_newTLC.Value = Format(txt_a_r4c3_newTLC.Value, "###")
    Me.txt_a_r4c4_newTLC.Value = Format(txt_a_r4c4_newTLC.Value, "###")
    Me.txt_a_r4c5_newTLC.Value = Format(txt_a_r4c5_newTLC.Value, "###")
    Me.txt_a_r4c6_newTLC.Value = Format(txt_a_r4c6_newTLC.Value, "###")

    Me.txt_a_r5c1_newTLC.Value = Format(txt_a_r5c1_newTLC.Value, "###")
    Me.txt_a_r5c2_newTLC.Value = Format(txt_a_r5c2_newTLC.Value, "###")
    Me.txt_a_r5c3_newTLC.Value = Format(txt_a_r5c3_newTLC.Value, "###")
    Me.txt_a_r5c4_newTLC.Value = Format(txt_a_r5c4_newTLC.Value, "###")
    Me.txt_a_r5c5_newTLC.Value = Format(txt_a_r5c5_newTLC.Value, "###")
    Me.txt_a_r5c6_newTLC.Value = Format(txt_a_r5c6_newTLC.Value, "###")

    Me.txt_a_r6c1_newTLC.Value = Format(txt_a_r6c1_newTLC.Value, "###")
    Me.txt_a_r6c2_newTLC.Value = Format(txt_a_r6c2_newTLC.Value, "###")
    Me.txt_a_r6c3_newTLC.Value = Format(txt_a_r6c3_newTLC.Value, "###")

    Me.txt_a_r7c1_newTLC.Value = Format(txt_a_r7c1_newTLC.Value, "###")
    Me.txt_a_r7c2_newTLC.Value = Format(txt_a_r7c2_newTLC.Value, "###")
    Me.txt_a_r7c3_newTLC.Value = Format(txt_a_r7c3_newTLC.Value, "###")
    Me.txt_a_r7c4_newTLC.Value = Format(txt_a_r7c4_newTLC.Value, "###")
    Me.txt_a_r7c5_newTLC.Value = Format(txt_a_r7c5_newTLC.Value, "###")
    Me.txt_a_r7c6_newTLC.Value = Format(txt_a_r7c6_newTLC.Value, "###")

    Me.txt_b_r1c1_newTLC.Value = Format(txt_b_r1c1_newTLC.Value, "###")
    Me.txt_b_r1c2_newTLC.Value = Format(txt_b_r1c2_newTLC.Value, "###")
    Me.txt_b_r1c3_newTLC.Value = Format(txt_b_r1c3_newTLC.Value, "###")
    Me.txt_b_r1c4_newTLC.Value = Format(txt_b_r1c4_newTLC.Value, "###")
    Me.txt_b_r1c5_newTLC.Value = Format(txt_b_r1c5_newTLC.Value, "###")
    Me.txt_b_r1c6_newTLC.Value = Format(txt_b_r1c6_newTLC.Value, "###")

    Me.txt_b_r2c1_newTLC.Value = Format(txt_b_r2c1_newTLC.Value, "###")
    Me.txt_b_r2c2_newTLC.Value = Format(txt_b_r2c2_newTLC.Value, "###")
    Me.txt_b_r2c3_newTLC.Value = Format(txt_b_r2c3_newTLC.Value, "###")
    Me.txt_b_r2c4_newTLC.Value = Format(txt_b_r2c4_newTLC.Value, "###")
    Me.txt_b_r2c5_newTLC.Value = Format(txt_b_r2c5_newTLC.Value, "###")
    Me.txt_b_r2c6_newTLC.Value = Format(txt_b_r2c6_newTLC.Value, "###")

    Me.txt_b_r3c1_newTLC.Value = Format(txt_b_r3c1_newTLC.Value, "###")
    Me.txt_b_r3c2_newTLC.Value = Format(txt_b_r3c2_newTLC.Value, "###")
    Me.txt_b_r3c3_newTLC.Value = Format(txt_b_r3c3_newTLC.Value, "###")
    Me.txt_b_r3c4_newTLC.Value = Format(txt_b_r3c4_newTLC.Value, "###")
    Me.txt_b_r3c5_newTLC.Value = Format(txt_b_r3c5_newTLC.Value, "###")
    Me.txt_b_r3c6_newTLC.Value = Format(txt_b_r3c6_newTLC.Value, "###")

    Me.txt_b_r4c1_newTLC.Value = Format(txt_b_r4c1_newTLC.Value, "###")
    Me.txt_b_r4c2_newTLC.Value = Format(txt_b_r4c2_newTLC.Value, "###")
    Me.txt_b_r4c3_newTLC.Value = Format(txt_b_r4c3_newTLC.Value, "###")
    Me.txt_b_r4c4_newTLC.Value = Format(txt_b_r4c4_newTLC.Value, "###")
    Me.txt_b_r4c5_newTLC.Value = Format(txt_b_r4c5_newTLC.Value, "###")
    Me.txt_b_r4c6_newTLC.Value = Format(txt_b_r4c6_newTLC.Value, "###")

    Me.txt_a_r1c1_newWAR.Value = Format(txt_a_r1c1_newWAR.Value, "###")
    Me.txt_a_r1c2_newWAR.Value = Format(txt_a_r1c2_newWAR.Value, "###")
    Me.txt_a_r1c3_newWAR.Value = Format(txt_a_r1c3_newWAR.Value, "###")
    Me.txt_a_r1c4_newWAR.Value = Format(txt_a_r1c4_newWAR.Value, "###")
    Me.txt_a_r1c5_newWAR.Value = Format(txt_a_r1c5_newWAR.Value, "###")
    Me.txt_a_r1c6_newWAR.Value = Format(txt_a_r1c6_newWAR.Value, "###")

    Me.txt_a_r2c1_newWAR.Value = Format(txt_a_r2c1_newWAR.Value, "###")
    Me.txt_a_r2c2_newWAR.Value = Format(txt_a_r2c2_newWAR.Value, "###")
    Me.txt_a_r2c3_newWAR.Value = Format(txt_a_r2c3_newWAR.Value, "###")
    Me.txt_a_r2c4_newWAR.Value = Format(txt_a_r2c4_newWAR.Value, "###")
    Me.txt_a_r2c5_newWAR.Value = Format(txt_a_r2c5_newWAR.Value, "###")
    Me.txt_a_r2c6_newWAR.Value = Format(txt_a_r2c6_newWAR.Value, "###")

    Me.txt_a_r3c1_newWAR.Value = Format(txt_a_r3c1_newWAR.Value, "###")
    Me.txt_a_r3c2_newWAR.Value = Format(txt_a_r3c2_newWAR.Value, "###")
    Me.txt_a_r3c3_newWAR.Value = Format(txt_a_r3c3_newWAR.Value, "###")
    Me.txt_a_r3c4_newWAR.Value = Format(txt_a_r3c4_newWAR.Value, "###")
    Me.txt_a_r3c5_newWAR.Value = Format(txt_a_r3c5_newWAR.Value, "###")
    Me.txt_a_r3c6_newWAR.Value = Format(txt_a_r3c6_newWAR.Value, "###")

    Me.txt_a_r4c1_newWAR.Value = Format(txt_a_r4c1_newWAR.Value, "###")
    Me.txt_a_r4c2_newWAR.Value = Format(txt_a_r4c2_newWAR.Value, "###")
    Me.txt_a_r4c3_newWAR.Value = Format(txt_a_r4c3_newWAR.Value, "###")
    Me.txt_a_r4c4_newWAR.Value = Format(txt_a_r4c4_newWAR.Value, "###")
    Me.txt_a_r4c5_newWAR.Value = Format(txt_a_r4c5_newWAR.Value, "###")
    Me.txt_a_r4c6_newWAR.Value = Format(txt_a_r4c6_newWAR.Value, "###")

    Me.txt_a_r5c1_newWAR.Value = Format(txt_a_r5c1_newWAR.Value, "###")
    Me.txt_a_r5c2_newWAR.Value = Format(txt_a_r5c2_newWAR.Value, "###")
    Me.txt_a_r5c3_newWAR.Value = Format(txt_a_r5c3_newWAR.Value, "###")
    Me.txt_a_r5c4_newWAR.Value = Format(txt_a_r5c4_newWAR.Value, "###")
    Me.txt_a_r5c5_newWAR.Value = Format(txt_a_r5c5_newWAR.Value, "###")
    Me.txt_a_r5c6_newWAR.Value = Format(txt_a_r5c6_newWAR.Value, "###")

    Me.txt_a_r6c1_newWAR.Value = Format(txt_a_r6c1_newWAR.Value, "###")
    Me.txt_a_r6c2_newWAR.Value = Format(txt_a_r6c2_newWAR.Value, "###")
    Me.txt_a_r6c3_newWAR.Value = Format(txt_a_r6c3_newWAR.Value, "###")
    Me.txt_a_r6c4_newWAR.Value = Format(txt_a_r6c4_newWAR.Value, "###")
    Me.txt_a_r6c5_newWAR.Value = Format(txt_a_r6c5_newWAR.Value, "###")
    Me.txt_a_r6c6_newWAR.Value = Format(txt_a_r6c6_newWAR.Value, "###")

    Me.txt_a_r7c1_newWAR.Value = Format(txt_a_r7c1_newWAR.Value, "###")
    Me.txt_a_r7c2_newWAR.Value = Format(txt_a_r7c2_newWAR.Value, "###")
    Me.txt_a_r7c3_newWAR.Value = Format(txt_a_r7c3_newWAR.Value, "###")
    Me.txt_a_r7c4_newWAR.Value = Format(txt_a_r7c4_newWAR.Value, "###")
    Me.txt_a_r7c5_newWAR.Value = Format(txt_a_r7c5_newWAR.Value, "###")
    Me.txt_a_r7c6_newWAR.Value = Format(txt_a_r7c6_newWAR.Value, "###")

    Me.txt_b_r1c1_newWAR.Value = Format(txt_b_r1c1_newWAR.Value, "###")
    Me.txt_b_r1c2_newWAR.Value = Format(txt_b_r1c2_newWAR.Value, "###")
    Me.txt_b_r1c3_newWAR.Value = Format(txt_b_r1c3_newWAR.Value, "###")
    Me.txt_b_r1c4_newWAR.Value = Format(txt_b_r1c4_newWAR.Value, "###")
    Me.txt_b_r1c5_newWAR.Value = Format(txt_b_r1c5_newWAR.Value, "###")
    Me.txt_b_r1c6_newWAR.Value = Format(txt_b_r1c6_newWAR.Value, "###")

    Me.txt_b_r2c1_newWAR.Value = Format(txt_b_r2c1_newWAR.Value, "###")
    Me.txt_b_r2c2_newWAR.Value = Format(txt_b_r2c2_newWAR.Value, "###")
    Me.txt_b_r2c3_newWAR.Value = Format(txt_b_r2c3_newWAR.Value, "###")
    Me.txt_b_r2c4_newWAR.Value = Format(txt_b_r2c4_newWAR.Value, "###")
    Me.txt_b_r2c5_newWAR.Value = Format(txt_b_r2c5_newWAR.Value, "###")
    Me.txt_b_r2c6_newWAR.Value = Format(txt_b_r2c6_newWAR.Value, "###")

    Me.txt_b_r3c1_newWAR.Value = Format(txt_b_r3c1_newWAR.Value, "###")
    Me.txt_b_r3c2_newWAR.Value = Format(txt_b_r3c2_newWAR.Value, "###")
    Me.txt_b_r3c3_newWAR.Value = Format(txt_b_r3c3_newWAR.Value, "###")
    Me.txt_b_r3c4_newWAR.Value = Format(txt_b_r3c4_newWAR.Value, "###")
    Me.txt_b_r3c5_newWAR.Value = Format(txt_b_r3c5_newWAR.Value, "###")
    Me.txt_b_r3c6_newWAR.Value = Format(txt_b_r3c6_newWAR.Value, "###")

    Me.txt_b_r4c1_newWAR.Value = Format(txt_b_r4c1_newWAR.Value, "###")
    Me.txt_b_r4c2_newWAR.Value = Format(txt_b_r4c2_newWAR.Value, "###")
    Me.txt_b_r4c3_newWAR.Value = Format(txt_b_r4c3_newWAR.Value, "###")
    Me.txt_b_r4c4_newWAR.Value = Format(txt_b_r4c4_newWAR.Value, "###")
    Me.txt_b_r4c5_newWAR.Value = Format(txt_b_r4c5_newWAR.Value, "###")
    Me.txt_b_r4c6_newWAR.Value = Format(txt_b_r4c6_newWAR.Value, "###")

    Me.txt_b_r5c1_newWAR.Value = Format(txt_b_r5c1_newWAR.Value, "###")
    Me.txt_b_r5c2_newWAR.Value = Format(txt_b_r5c2_newWAR.Value, "###")
    Me.txt_b_r5c3_newWAR.Value = Format(txt_b_r5c3_newWAR.Value, "###")
    Me.txt_b_r5c4_newWAR.Value = Format(txt_b_r5c4_newWAR.Value, "###")
    Me.txt_b_r5c5_newWAR.Value = Format(txt_b_r5c5_newWAR.Value, "###")
    Me.txt_b_r5c6_newWAR.Value = Format(txt_b_r5c6_newWAR.Value, "###")

    Me.txt_b_r6c1_newWAR.Value = Format(txt_b_r6c1_newWAR.Value, "###")
    Me.txt_b_r6c2_newWAR.Value = Format(txt_b_r6c2_newWAR.Value, "###")
    Me.txt_b_r6c3_newWAR.Value = Format(txt_b_r6c3_newWAR.Value, "###")
    Me.txt_b_r6c4_newWAR.Value = Format(txt_b_r6c4_newWAR.Value, "###")
    Me.txt_b_r6c5_newWAR.Value = Format(txt_b_r6c5_newWAR.Value, "###")
    Me.txt_b_r6c6_newWAR.Value = Format(txt_b_r6c6_newWAR.Value, "###")

    Me.txt_b_r7c1_newWAR.Value = Format(txt_b_r7c1_newWAR.Value, "###")
    Me.txt_b_r7c2_newWAR.Value = Format(txt_b_r7c2_newWAR.Value, "###")
    Me.txt_b_r7c3_newWAR.Value = Format(txt_b_r7c3_newWAR.Value, "###")
    Me.txt_b_r7c4_newWAR.Value = Format(txt_b_r7c4_newWAR.Value, "###")
    Me.txt_b_r7c5_newWAR.Value = Format(txt_b_r7c5_newWAR.Value, "###")
    Me.txt_b_r7c6_newWAR.Value = Format(txt_b_r7c6_newWAR.Value, "###")

    Me.txt_a_r1c1_newRAN.Value = Format(txt_a_r1c1_newRAN.Value, "###")
    Me.txt_a_r1c2_newRAN.Value = Format(txt_a_r1c2_newRAN.Value, "###")
    Me.txt_a_r1c3_newRAN.Value = Format(txt_a_r1c3_newRAN.Value, "###")
    Me.txt_a_r1c4_newRAN.Value = Format(txt_a_r1c4_newRAN.Value, "###")
    Me.txt_a_r1c5_newRAN.Value = Format(txt_a_r1c5_newRAN.Value, "###")
    Me.txt_a_r1c6_newRAN.Value = Format(txt_a_r1c6_newRAN.Value, "###")

    Me.txt_a_r2c1_newRAN.Value = Format(txt_a_r2c1_newRAN.Value, "###")
    Me.txt_a_r2c2_newRAN.Value = Format(txt_a_r2c2_newRAN.Value, "###")
    Me.txt_a_r2c3_newRAN.Value = Format(txt_a_r2c3_newRAN.Value, "###")
    Me.txt_a_r2c4_newRAN.Value = Format(txt_a_r2c4_newRAN.Value, "###")
    Me.txt_a_r2c5_newRAN.Value = Format(txt_a_r2c5_newRAN.Value, "###")
    Me.txt_a_r2c6_newRAN.Value = Format(txt_a_r2c6_newRAN.Value, "###")
    Me.txt_a_r2c7_newRAN.Value = Format(txt_a_r2c7_newRAN.Value, "###")

    Me.txt_a_r3c1_newRAN.Value = Format(txt_a_r3c1_newRAN.Value, "###")
    Me.txt_a_r3c2_newRAN.Value = Format(txt_a_r3c2_newRAN.Value, "###")
    Me.txt_a_r3c3_newRAN.Value = Format(txt_a_r3c3_newRAN.Value, "###")
    Me.txt_a_r3c4_newRAN.Value = Format(txt_a_r3c4_newRAN.Value, "###")
    Me.txt_a_r3c5_newRAN.Value = Format(txt_a_r3c5_newRAN.Value, "###")
    Me.txt_a_r3c6_newRAN.Value = Format(txt_a_r3c6_newRAN.Value, "###")
    Me.txt_a_r3c7_newRAN.Value = Format(txt_a_r3c7_newRAN.Value, "###")

    Me.txt_a_r4c1_newRAN.Value = Format(txt_a_r4c1_newRAN.Value, "###")
    Me.txt_a_r4c2_newRAN.Value = Format(txt_a_r4c2_newRAN.Value, "###")
    Me.txt_a_r4c3_newRAN.Value = Format(txt_a_r4c3_newRAN.Value, "###")
    Me.txt_a_r4c4_newRAN.Value = Format(txt_a_r4c4_newRAN.Value, "###")
    Me.txt_a_r4c5_newRAN.Value = Format(txt_a_r4c5_newRAN.Value, "###")
    Me.txt_a_r4c6_newRAN.Value = Format(txt_a_r4c6_newRAN.Value, "###")
    Me.txt_a_r4c7_newRAN.Value = Format(txt_a_r4c7_newRAN.Value, "###")

    Me.txt_a_r5c1_newRAN.Value = Format(txt_a_r5c1_newRAN.Value, "###")
    Me.txt_a_r5c2_newRAN.Value = Format(txt_a_r5c2_newRAN.Value, "###")
    Me.txt_a_r5c3_newRAN.Value = Format(txt_a_r5c3_newRAN.Value, "###")
    Me.txt_a_r5c4_newRAN.Value = Format(txt_a_r5c4_newRAN.Value, "###")
    Me.txt_a_r5c5_newRAN.Value = Format(txt_a_r5c5_newRAN.Value, "###")
    Me.txt_a_r5c6_newRAN.Value = Format(txt_a_r5c6_newRAN.Value, "###")
    Me.txt_a_r5c7_newRAN.Value = Format(txt_a_r5c7_newRAN.Value, "###")

    Me.txt_a_r6c1_newRAN.Value = Format(txt_a_r6c1_newRAN.Value, "###")
    Me.txt_a_r6c2_newRAN.Value = Format(txt_a_r6c2_newRAN.Value, "###")
    Me.txt_a_r6c3_newRAN.Value = Format(txt_a_r6c3_newRAN.Value, "###")
    Me.txt_a_r6c4_newRAN.Value = Format(txt_a_r6c4_newRAN.Value, "###")
    Me.txt_a_r6c5_newRAN.Value = Format(txt_a_r6c5_newRAN.Value, "###")
    Me.txt_a_r6c6_newRAN.Value = Format(txt_a_r6c6_newRAN.Value, "###")
    Me.txt_a_r6c7_newRAN.Value = Format(txt_a_r6c7_newRAN.Value, "###")

    Me.txt_a_r7c1_newRAN.Value = Format(txt_a_r7c1_newRAN.Value, "###")
    Me.txt_a_r7c2_newRAN.Value = Format(txt_a_r7c2_newRAN.Value, "###")
    Me.txt_a_r7c3_newRAN.Value = Format(txt_a_r7c3_newRAN.Value, "###")
    Me.txt_a_r7c4_newRAN.Value = Format(txt_a_r7c4_newRAN.Value, "###")
    Me.txt_a_r7c5_newRAN.Value = Format(txt_a_r7c5_newRAN.Value, "###")
    Me.txt_a_r7c6_newRAN.Value = Format(txt_a_r7c6_newRAN.Value, "###")
    Me.txt_a_r7c7_newRAN.Value = Format(txt_a_r7c7_newRAN.Value, "###")
 
End Sub
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question Question
Userform not starting in the center of the sheet
Replies
2
Views
643
SantanaKRE8s
S
JeffGrant
  • Solved
Userform throwing Error 91
Replies
4
Views
552
Domenic
D
D
  • Question Question
Macro will protect worksheet, but will not unprotect
Replies
3
Views
715
rlv01
R
U
  • Solved
Simple VBA code freezes/crashes Excel
Replies
2
Views
321
ubergreen
U
F
  • Question Question
Making a UserForm behave as a Tool Window for another process
Replies
3
Views
226
fitzmorrispr
F

Forum statistics

Threads
1,223,231
Messages
6,170,884
Members
452,364
Latest member
springate

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top