Problem using CONTROLSOURCE... only works when sheet5 is active

B

Benjamin

I have a problem using controlsource,
it's really picky,
it only appears to work in the form when I have Fixed Tables Sheet as the
active sheet, What is keeping me from seeing the values when another sheet or
excel document is active. I use these textboxes on a form that the user fills
out and then it populates different *.xls and *.doc files and populates them
when the user clicks the appropriate generate form button.

I'm creating a miny database of sorts using the cells in Excel, I know it's
not recommended, and some would suggest I use Access, but they won't allow us
to use access at this site, and Excel does the job sufficiently.

My code is below, can someone explain why the control source only works if
the Fixed Tables Sheet is the one in the foreground, as it would help me as
I'm designing this form creator tool.

-Regards, -BC


Private Sub UserForm_Initialize()
Dim currfile As String
currfile = ThisWorkbook.Name
Workbooks(currfile).Activate 'Activates Current Workbook
ThisWorkbook.Sheets("Fixed Tables").Activate


'Control Source
FrmMTCLog.txtSuction1.ControlSource = Worksheets("Fixed
Tables").Range("Y2").Address
FrmMTCLog.txtSuction1.ControlSource = Worksheets("Fixed
Tables").Range("y2").Address
FrmMTCLog.txtSuction2.ControlSource = Worksheets("Fixed
Tables").Range("y3").Address
FrmMTCLog.txtSuction3.ControlSource = Worksheets("Fixed
Tables").Range("y4").Address
FrmMTCLog.txtSuction4.ControlSource = Worksheets("Fixed
Tables").Range("y5").Address
FrmMTCLog.txtSuction5.ControlSource = Worksheets("Fixed
Tables").Range("y6").Address
FrmMTCLog.txtSuction6.ControlSource = Worksheets("Fixed
Tables").Range("y7").Address
FrmMTCLog.txtSuction7.ControlSource = Worksheets("Fixed
Tables").Range("y8").Address
FrmMTCLog.txtSuction8.ControlSource = Worksheets("Fixed
Tables").Range("y9").Address
FrmMTCLog.txtSuction9.ControlSource = Worksheets("Fixed
Tables").Range("y10").Address
FrmMTCLog.txtDischarge1.ControlSource = Worksheets("Fixed
Tables").Range("AA2").Address
FrmMTCLog.txtDischarge2.ControlSource = Worksheets("Fixed
Tables").Range("AA3").Address
FrmMTCLog.txtDischarge3.ControlSource = Worksheets("Fixed
Tables").Range("AA4").Address
FrmMTCLog.txtDischarge4.ControlSource = Worksheets("Fixed
Tables").Range("AA5").Address
FrmMTCLog.txtDischarge5.ControlSource = Worksheets("Fixed
Tables").Range("AA6").Address
FrmMTCLog.txtDischarge6.ControlSource = Worksheets("Fixed
Tables").Range("AA7").Address
FrmMTCLog.txtDischarge7.ControlSource = Worksheets("Fixed
Tables").Range("AA8").Address
FrmMTCLog.txtDischarge8.ControlSource = Worksheets("Fixed
Tables").Range("AA9").Address
FrmMTCLog.txtDischarge9.ControlSource = Worksheets("Fixed
Tables").Range("AA10").Address
FrmMTCLog.txtpump1.ControlSource = Worksheets("Fixed
Tables").Range("AJ2").Address
FrmMTCLog.txtpump2.ControlSource = Worksheets("Fixed
Tables").Range("AJ3").Address
FrmMTCLog.txtpump3.ControlSource = Worksheets("Fixed
Tables").Range("AJ4").Address
FrmMTCLog.txtpump4.ControlSource = Worksheets("Fixed
Tables").Range("AJ5").Address
FrmMTCLog.txtpump5.ControlSource = Worksheets("Fixed
Tables").Range("AN2").Address
FrmMTCLog.txtpump6.ControlSource = Worksheets("Fixed
Tables").Range("AN3").Address
FrmMTCLog.txtpump7.ControlSource = Worksheets("Fixed
Tables").Range("AN4").Address
FrmMTCLog.txtpump8.ControlSource = Worksheets("Fixed
Tables").Range("AN5").Address
FrmMTCLog.txtpump9.ControlSource = Worksheets("Fixed
Tables").Range("AN6").Address
FrmMTCLog.txtpump10.ControlSource = Worksheets("Fixed
Tables").Range("AQ2").Address
FrmMTCLog.txtpump11.ControlSource = Worksheets("Fixed
Tables").Range("AQ3").Address
FrmMTCLog.txtpump12.ControlSource = Worksheets("Fixed
Tables").Range("AQ4").Address
FrmMTCLog.TextBox26.ControlSource = Worksheets("Fixed
Tables").Range("O3").Address
FrmMTCLog.TextBox27.ControlSource = Worksheets("Fixed
Tables").Range("O4").Address
FrmMTCLog.TextBox28.ControlSource = Worksheets("Fixed
Tables").Range("O5").Address
FrmMTCLog.TextBox29.ControlSource = Worksheets("Fixed
Tables").Range("Q3").Address
FrmMTCLog.TextBox30.ControlSource = Worksheets("Fixed
Tables").Range("Q4").Address
FrmMTCLog.TextBox31.ControlSource = Worksheets("Fixed
Tables").Range("Q5").Address
FrmMTCLog.TextBox32.ControlSource = Worksheets("Fixed
Tables").Range("R3").Address
FrmMTCLog.TextBox33.ControlSource = Worksheets("Fixed
Tables").Range("R4").Address
FrmMTCLog.TextBox34.ControlSource = Worksheets("Fixed
Tables").Range("R5").Address
FrmMTCLog.TextBox35.ControlSource = Worksheets("Fixed
Tables").Range("S3").Address
FrmMTCLog.TextBox36.ControlSource = Worksheets("Fixed
Tables").Range("S4").Address
FrmMTCLog.TextBox37.ControlSource = Worksheets("Fixed
Tables").Range("S5").Address
FrmMTCLog.TextBox11.ControlSource = Worksheets("Fixed
Tables").Range("AD3").Address
FrmMTCLog.TextBox12.ControlSource = Worksheets("Fixed
Tables").Range("AD4").Address
FrmMTCLog.TextBox13.ControlSource = Worksheets("Fixed
Tables").Range("AD5").Address
FrmMTCLog.TextBox14.ControlSource = Worksheets("Fixed
Tables").Range("AD6").Address
FrmMTCLog.TextBox15.ControlSource = Worksheets("Fixed
Tables").Range("AD7").Address
FrmMTCLog.TextBox16.ControlSource = Worksheets("Fixed
Tables").Range("AE3").Address
FrmMTCLog.TextBox17.ControlSource = Worksheets("Fixed
Tables").Range("AE4").Address
FrmMTCLog.TextBox18.ControlSource = Worksheets("Fixed
Tables").Range("AE5").Address
FrmMTCLog.TextBox19.ControlSource = Worksheets("Fixed
Tables").Range("AE6").Address
FrmMTCLog.TextBox20.ControlSource = Worksheets("Fixed
Tables").Range("AE7").Address
FrmMTCLog.TextBox21.ControlSource = Worksheets("Fixed
Tables").Range("AF3").Address
FrmMTCLog.TextBox22.ControlSource = Worksheets("Fixed
Tables").Range("AF4").Address
FrmMTCLog.TextBox23.ControlSource = Worksheets("Fixed
Tables").Range("AF5").Address
FrmMTCLog.TextBox24.ControlSource = Worksheets("Fixed
Tables").Range("AF6").Address
FrmMTCLog.TextBox25.ControlSource = Worksheets("Fixed
Tables").Range("AF7").Address
FrmMTCLog.TextBox1.ControlSource = Worksheets("Fixed
Tables").Range("I2").Address
FrmMTCLog.TextBox2.ControlSource = Worksheets("Fixed
Tables").Range("I3").Address
FrmMTCLog.TextBox3.ControlSource = Worksheets("Fixed
Tables").Range("I4").Address
FrmMTCLog.TextBox4.ControlSource = Worksheets("Fixed
Tables").Range("I5").Address
FrmMTCLog.TextBox41.ControlSource = Worksheets("Fixed
Tables").Range("u2").Address
FrmMTCLog.TextBox42.ControlSource = Worksheets("Fixed
Tables").Range("u3").Address
FrmMTCLog.TextBox43.ControlSource = Worksheets("Fixed
Tables").Range("u4").Address
FrmMTCLog.TextBox44.ControlSource = Worksheets("Fixed
Tables").Range("w2").Address
FrmMTCLog.TextBox45.ControlSource = Worksheets("Fixed
Tables").Range("w3").Address
FrmMTCLog.TextBox46.ControlSource = Worksheets("Fixed
Tables").Range("w4").Address
FrmMTCLog.TextBox50.ControlSource = Worksheets("Fixed
Tables").Range("AV2").Address
FrmMTCLog.TextBox51.ControlSource = Worksheets("Fixed
Tables").Range("AV3").Address
FrmMTCLog.TextBox52.ControlSource = Worksheets("Fixed
Tables").Range("AV4").Address
FrmMTCLog.TextBox53.ControlSource = Worksheets("Fixed
Tables").Range("AV5").Address
FrmMTCLog.TextBox54.ControlSource = Worksheets("Fixed
Tables").Range("AV6").Address
FrmMTCLog.TextBox55.ControlSource = Worksheets("Fixed
Tables").Range("AV7").Address
FrmMTCLog.TextBox56.ControlSource = Worksheets("Fixed
Tables").Range("AV8").Address
FrmMTCLog.TextBox57.ControlSource = Worksheets("Fixed
Tables").Range("AV9").Address
FrmMTCLog.TextBox58.ControlSource = Worksheets("Fixed
Tables").Range("AV10").Address
FrmMTCLog.TextBox59.ControlSource = Worksheets("Fixed
Tables").Range("AV11").Address
FrmMTCLog.TextBox60.ControlSource = Worksheets("Fixed
Tables").Range("AV12").Address
FrmMTCLog.TextBox61.ControlSource = Worksheets("Fixed
Tables").Range("AV13").Address
FrmMTCLog.TextBox62.ControlSource = Worksheets("Fixed
Tables").Range("AV14").Address
FrmMTCLog.TextBox63.ControlSource = Worksheets("Fixed
Tables").Range("AV15").Address
FrmMTCLog.TextBox64.ControlSource = Worksheets("Fixed
Tables").Range("AV16").Address
FrmMTCLog.TextBox65.ControlSource = Worksheets("Fixed
Tables").Range("AV17").Address
FrmMTCLog.TextBox66.ControlSource = Worksheets("Fixed
Tables").Range("AV18").Address
FrmMTCLog.TextBox67.ControlSource = Worksheets("Fixed
Tables").Range("AV19").Address
FrmMTCLog.TextBox68.ControlSource = Worksheets("Fixed
Tables").Range("AV20").Address
FrmMTCLog.TextBox69.ControlSource = Worksheets("Fixed
Tables").Range("AV21").Address
FrmMTCLog.TextBox70.ControlSource = Worksheets("Fixed
Tables").Range("AV22").Address
FrmMTCLog.TextBox71.ControlSource = Worksheets("Fixed
Tables").Range("AV23").Address
FrmMTCLog.TextBox72.ControlSource = Worksheets("Fixed
Tables").Range("AV24").Address
FrmMTCLog.TextBox73.ControlSource = Worksheets("Fixed
Tables").Range("AV25").Address
FrmMTCLog.TextBox74.ControlSource = Worksheets("Fixed
Tables").Range("AV26").Address
FrmMTCLog.TextBox75.ControlSource = Worksheets("Fixed
Tables").Range("AV27").Address
FrmMTCLog.TextBox76.ControlSource = Worksheets("Fixed
Tables").Range("AV28").Address
FrmMTCLog.TextBox77.ControlSource = Worksheets("Fixed
Tables").Range("AV29").Address
FrmMTCLog.TextBox78.ControlSource = Worksheets("Fixed
Tables").Range("AV30").Address
FrmMTCLog.TextBox79.ControlSource = Worksheets("Fixed
Tables").Range("AV31").Address
FrmMTCLog.TextBox80.ControlSource = Worksheets("Fixed
Tables").Range("AV32").Address
FrmMTCLog.TextBox81.ControlSource = Worksheets("Fixed
Tables").Range("AV33").Address
FrmMTCLog.TextBox124.ControlSource = Worksheets("Fixed
Tables").Range("AX2").Address
FrmMTCLog.TextBox125.ControlSource = Worksheets("Fixed
Tables").Range("AX3").Address
FrmMTCLog.TextBox126.ControlSource = Worksheets("Fixed
Tables").Range("AX4").Address
FrmMTCLog.TextBox127.ControlSource = Worksheets("Fixed
Tables").Range("AX5").Address
FrmMTCLog.TextBox128.ControlSource = Worksheets("Fixed
Tables").Range("AX6").Address
FrmMTCLog.TextBox129.ControlSource = Worksheets("Fixed
Tables").Range("AX7").Address
FrmMTCLog.TextBox130.ControlSource = Worksheets("Fixed
Tables").Range("AX8").Address
FrmMTCLog.TextBox131.ControlSource = Worksheets("Fixed
Tables").Range("AY2").Address
FrmMTCLog.TextBox132.ControlSource = Worksheets("Fixed
Tables").Range("AY3").Address
FrmMTCLog.TextBox133.ControlSource = Worksheets("Fixed
Tables").Range("AY4").Address
FrmMTCLog.TextBox134.ControlSource = Worksheets("Fixed
Tables").Range("AY5").Address
FrmMTCLog.TextBox135.ControlSource = Worksheets("Fixed
Tables").Range("AY6").Address
FrmMTCLog.TextBox136.ControlSource = Worksheets("Fixed
Tables").Range("AY7").Address
FrmMTCLog.TextBox137.ControlSource = Worksheets("Fixed
Tables").Range("AY8").Address
FrmMTCLog.TextBox138.ControlSource = Worksheets("Fixed
Tables").Range("AZ2").Address
FrmMTCLog.TextBox139.ControlSource = Worksheets("Fixed
Tables").Range("AZ3").Address
FrmMTCLog.TextBox140.ControlSource = Worksheets("Fixed
Tables").Range("AZ4").Address
FrmMTCLog.TextBox141.ControlSource = Worksheets("Fixed
Tables").Range("AZ5").Address
FrmMTCLog.TextBox142.ControlSource = Worksheets("Fixed
Tables").Range("AZ6").Address
FrmMTCLog.TextBox143.ControlSource = Worksheets("Fixed
Tables").Range("AZ7").Address
FrmMTCLog.TextBox144.ControlSource = Worksheets("Fixed
Tables").Range("AZ8").Address
FrmMTCLog.TextBox145.ControlSource = Worksheets("Fixed
Tables").Range("BA2").Address
FrmMTCLog.TextBox146.ControlSource = Worksheets("Fixed
Tables").Range("BA3").Address
FrmMTCLog.TextBox147.ControlSource = Worksheets("Fixed
Tables").Range("BA4").Address
FrmMTCLog.TextBox148.ControlSource = Worksheets("Fixed
Tables").Range("BA5").Address
FrmMTCLog.TextBox149.ControlSource = Worksheets("Fixed
Tables").Range("BA6").Address
FrmMTCLog.TextBox150.ControlSource = Worksheets("Fixed
Tables").Range("BA7").Address
FrmMTCLog.TextBox151.ControlSource = Worksheets("Fixed
Tables").Range("BA8").Address
FrmMTCLog.TextBox152.ControlSource = Worksheets("Fixed
Tables").Range("BB2").Address
FrmMTCLog.TextBox153.ControlSource = Worksheets("Fixed
Tables").Range("BB3").Address
FrmMTCLog.TextBox154.ControlSource = Worksheets("Fixed
Tables").Range("BB4").Address
FrmMTCLog.TextBox155.ControlSource = Worksheets("Fixed
Tables").Range("BB5").Address
FrmMTCLog.TextBox156.ControlSource = Worksheets("Fixed
Tables").Range("BB6").Address
FrmMTCLog.TextBox157.ControlSource = Worksheets("Fixed
Tables").Range("BB7").Address
FrmMTCLog.TextBox158.ControlSource = Worksheets("Fixed
Tables").Range("BB8").Address
FrmMTCLog.TextBox159.ControlSource = Worksheets("Fixed
Tables").Range("be2").Address
FrmMTCLog.TextBox160.ControlSource = Worksheets("Fixed
Tables").Range("be3").Address
FrmMTCLog.TextBox161.ControlSource = Worksheets("Fixed
Tables").Range("be4").Address
FrmMTCLog.TextBox162.ControlSource = Worksheets("Fixed
Tables").Range("be5").Address
FrmMTCLog.TextBox163.ControlSource = Worksheets("Fixed
Tables").Range("be6").Address
FrmMTCLog.TextBox164.ControlSource = Worksheets("Fixed
Tables").Range("be7").Address
FrmMTCLog.TextBox165.ControlSource = Worksheets("Fixed
Tables").Range("be8").Address
FrmMTCLog.TextBox166.ControlSource = Worksheets("Fixed
Tables").Range("be9").Address
FrmMTCLog.TextBox167.ControlSource = Worksheets("Fixed
Tables").Range("BG2").Address
FrmMTCLog.TextBox168.ControlSource = Worksheets("Fixed
Tables").Range("BG3").Address
FrmMTCLog.TextBox169.ControlSource = Worksheets("Fixed
Tables").Range("BG4").Address
FrmMTCLog.TextBox170.ControlSource = Worksheets("Fixed
Tables").Range("BG5").Address
FrmMTCLog.TextBox171.ControlSource = Worksheets("Fixed
Tables").Range("BG6").Address
FrmMTCLog.TextBox172.ControlSource = Worksheets("Fixed
Tables").Range("BG7").Address
FrmMTCLog.TextBox173.ControlSource = Worksheets("Fixed
Tables").Range("BG8").Address
FrmMTCLog.TextBox174.ControlSource = Worksheets("Fixed
Tables").Range("BG9").Address
FrmMTCLog.TextBox175.ControlSource = Worksheets("Fixed
Tables").Range("BG10").Address
FrmMTCLog.TextBox176.ControlSource = Worksheets("Fixed
Tables").Range("BG11").Address
FrmMTCLog.TextBox177.ControlSource = Worksheets("Fixed
Tables").Range("BG12").Address
FrmMTCLog.TextBox178.ControlSource = Worksheets("Fixed
Tables").Range("BG13").Address
FrmMTCLog.TextBox179.ControlSource = Worksheets("Fixed
Tables").Range("BG14").Address
FrmMTCLog.TextBox180.ControlSource = Worksheets("Fixed
Tables").Range("BG15").Address
FrmMTCLog.TextBox181.ControlSource = Worksheets("Fixed
Tables").Range("BG16").Address
FrmMTCLog.TextBox182.ControlSource = Worksheets("Fixed
Tables").Range("BH2").Address
FrmMTCLog.TextBox183.ControlSource = Worksheets("Fixed
Tables").Range("BH3").Address
FrmMTCLog.TextBox184.ControlSource = Worksheets("Fixed
Tables").Range("BH4").Address
FrmMTCLog.TextBox185.ControlSource = Worksheets("Fixed
Tables").Range("BH5").Address
FrmMTCLog.TextBox186.ControlSource = Worksheets("Fixed
Tables").Range("BH6").Address
FrmMTCLog.TextBox187.ControlSource = Worksheets("Fixed
Tables").Range("BH7").Address
FrmMTCLog.TextBox188.ControlSource = Worksheets("Fixed
Tables").Range("BH8").Address
FrmMTCLog.TextBox189.ControlSource = Worksheets("Fixed
Tables").Range("BH9").Address
FrmMTCLog.TextBox191.ControlSource = Worksheets("Fixed
Tables").Range("BH11").Address
FrmMTCLog.TextBox192.ControlSource = Worksheets("Fixed
Tables").Range("BH12").Address
FrmMTCLog.TextBox193.ControlSource = Worksheets("Fixed
Tables").Range("BH13").Address
FrmMTCLog.TextBox194.ControlSource = Worksheets("Fixed
Tables").Range("BH14").Address
FrmMTCLog.TextBox195.ControlSource = Worksheets("Fixed
Tables").Range("BH15").Address
FrmMTCLog.TextBox196.ControlSource = Worksheets("Fixed
Tables").Range("BH16").Address
FrmMTCLog.TextBox197.ControlSource = Worksheets("Fixed
Tables").Range("BJ2").Address
FrmMTCLog.TextBox198.ControlSource = Worksheets("Fixed
Tables").Range("BJ3").Address
FrmMTCLog.TextBox199.ControlSource = Worksheets("Fixed
Tables").Range("BJ4").Address
FrmMTCLog.TextBox200.ControlSource = Worksheets("Fixed
Tables").Range("BJ5").Address
FrmMTCLog.TextBox201.ControlSource = Worksheets("Fixed
Tables").Range("BJ6").Address
FrmMTCLog.TextBox202.ControlSource = Worksheets("Fixed
Tables").Range("BJ7").Address
FrmMTCLog.TextBox203.ControlSource = Worksheets("Fixed
Tables").Range("BJ8").Address
FrmMTCLog.TextBox204.ControlSource = Worksheets("Fixed
Tables").Range("BJ9").Address
FrmMTCLog.TextBox205.ControlSource = Worksheets("Fixed
Tables").Range("BJ10").Address
FrmMTCLog.TextBox206.ControlSource = Worksheets("Fixed
Tables").Range("BJ11").Address
FrmMTCLog.TextBox207.ControlSource = Worksheets("Fixed
Tables").Range("BJ12").Address
FrmMTCLog.TextBox208.ControlSource = Worksheets("Fixed
Tables").Range("BJ13").Address
FrmMTCLog.TextBox209.ControlSource = Worksheets("Fixed
Tables").Range("BJ14").Address
FrmMTCLog.TextBox210.ControlSource = Worksheets("Fixed
Tables").Range("BJ15").Address
FrmMTCLog.TextBox211.ControlSource = Worksheets("Fixed
Tables").Range("BJ16").Address
FrmMTCLog.TextBox212.ControlSource = Worksheets("Fixed
Tables").Range("BK2").Address
FrmMTCLog.TextBox213.ControlSource = Worksheets("Fixed
Tables").Range("BK3").Address
FrmMTCLog.TextBox214.ControlSource = Worksheets("Fixed
Tables").Range("BK4").Address
FrmMTCLog.TextBox215.ControlSource = Worksheets("Fixed
Tables").Range("BK5").Address
FrmMTCLog.TextBox216.ControlSource = Worksheets("Fixed
Tables").Range("BK6").Address
FrmMTCLog.TextBox217.ControlSource = Worksheets("Fixed
Tables").Range("BK7").Address
FrmMTCLog.TextBox218.ControlSource = Worksheets("Fixed
Tables").Range("BK8").Address
FrmMTCLog.TextBox219.ControlSource = Worksheets("Fixed
Tables").Range("BK9").Address
FrmMTCLog.TextBox220.ControlSource = Worksheets("Fixed
Tables").Range("BK10").Address
FrmMTCLog.TextBox221.ControlSource = Worksheets("Fixed
Tables").Range("BK11").Address
FrmMTCLog.TextBox222.ControlSource = Worksheets("Fixed
Tables").Range("BK12").Address
FrmMTCLog.TextBox223.ControlSource = Worksheets("Fixed
Tables").Range("BK13").Address
FrmMTCLog.TextBox224.ControlSource = Worksheets("Fixed
Tables").Range("BK14").Address
FrmMTCLog.TextBox225.ControlSource = Worksheets("Fixed
Tables").Range("BK15").Address
FrmMTCLog.TextBox226.ControlSource = Worksheets("Fixed
Tables").Range("BK16").Address
FrmMTCLog.TextBox227.ControlSource = Worksheets("Fixed
Tables").Range("BM2").Address
FrmMTCLog.TextBox228.ControlSource = Worksheets("Fixed
Tables").Range("BM3").Address
FrmMTCLog.TextBox229.ControlSource = Worksheets("Fixed
Tables").Range("BM4").Address
FrmMTCLog.TextBox230.ControlSource = Worksheets("Fixed
Tables").Range("BM5").Address
FrmMTCLog.TextBox231.ControlSource = Worksheets("Fixed
Tables").Range("BM6").Address
FrmMTCLog.TextBox232.ControlSource = Worksheets("Fixed
Tables").Range("BN2").Address
FrmMTCLog.TextBox233.ControlSource = Worksheets("Fixed
Tables").Range("BN3").Address
FrmMTCLog.TextBox234.ControlSource = Worksheets("Fixed
Tables").Range("BN4").Address
FrmMTCLog.TextBox235.ControlSource = Worksheets("Fixed
Tables").Range("BN5").Address
FrmMTCLog.TextBox236.ControlSource = Worksheets("Fixed
Tables").Range("BN6").Address
FrmMTCLog.TextBox237.ControlSource = Worksheets("Fixed
Tables").Range("BO2").Address
FrmMTCLog.TextBox238.ControlSource = Worksheets("Fixed
Tables").Range("BO3").Address
FrmMTCLog.TextBox239.ControlSource = Worksheets("Fixed
Tables").Range("BO4").Address
FrmMTCLog.TextBox240.ControlSource = Worksheets("Fixed
Tables").Range("BO5").Address
FrmMTCLog.TextBox241.ControlSource = Worksheets("Fixed
Tables").Range("BO6").Address


'Load Operations Data
ComboBox1.Value = Workbooks(currfile).Worksheets("Operations").Range("c2")
ComboBox2.Value = Workbooks(currfile).Worksheets("Operations").Range("d2")
ComboBox3.Value = Workbooks(currfile).Worksheets("Operations").Range("e2")
ComboBox4.Value = Workbooks(currfile).Worksheets("Operations").Range("f2")
ComboBox5.Value = Workbooks(currfile).Worksheets("Operations").Range("g2")
ComboBox6.Value = Workbooks(currfile).Worksheets("Operations").Range("h2")
ComboBox7.Value = Workbooks(currfile).Worksheets("Operations").Range("i2")



End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

WARNING: Opinion 4

Top