Excel freezes userform on Launch but ok in VBA

03856me

Active Member
Joined
Apr 4, 2008
Messages
261
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
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
19,193
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?
 

03856me

Active Member
Joined
Apr 4, 2008
Messages
261
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?
 

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
19,193
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?
 

03856me

Active Member
Joined
Apr 4, 2008
Messages
261
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.
 

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
19,193
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.
 

03856me

Active Member
Joined
Apr 4, 2008
Messages
261
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
 

Watch MrExcel Video

Forum statistics

Threads
1,099,969
Messages
5,471,755
Members
406,781
Latest member
aproberts1980

This Week's Hot Topics

Top