Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem using CONTROLSOURCE... only works when sheet5 is active
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ControlSource and Localization Issue?? (run-time error '380' Could not set the ControlSource property) | Excel Programming | |||
userform checkbox problem with controlsource | Excel Programming | |||
How can you open a tab(Sheet5) by clicking on particular cell say. | Excel Programming | |||
Problem with TextBox & ControlSource - Please Help | Excel Programming | |||
ControlSource problem | Excel Programming |