[VBA ] 一個問題

看板Visual_Basic作者ntcblin ( )時間17年前 (2006/11/01 17:45)推噓4(4推 0噓 1→)

留言5則, 3人參與討論串1/2 (看更多)

請問什麼是程式處於中斷模式我要怎麼除錯呢 thanks 這是我的程式 Public Sub dee() Dim pra As Double Dim ra As Double Dim na As Double Dim mp As Double Dim rb As Double Dim nb As Double Dim mpa As Double Dim mpl As Double pra = Worksheets("sheet1").Cells(3, 1).Value ra = Worksheets("sheet1").Cells(3, 2).Value na = Worksheets("sheet1").Cells(3, 3).Value mp = Worksheets("sheet1").Cells(10, 1).Value rb = Worksheets("sheet1").Cells(10, 2).Value nb = Worksheets("sheet1").Cells(10, 3).Value mpa = pra * (ra / 12) / (1 - (1 / (1 + (ra / 12) ^ na))) mpl = mp * (1 - (1 / (1 + rb / 12) ^ nb)) / (rb / 12) Worksheets("sheet1").Cells(6, 1).Value = mpa Worksheets("sheet1").Cells(13, 1).Value = mpl End Sub -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 140.114.132.196

推

qsss

11/01 18:05, , 1^F

11/01 18:05, 1^F

推

commiserate

11/01 18:15, , 2^F

11/01 18:15, 2^F

→

commiserate

11/01 18:15, , 3^F

11/01 18:15, 3^F