[VBA ] 一個問題

[ntcblin ( )]

  請問 什麼是程式處於中斷模式

我要怎麼除錯呢 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:你的問題好像跟程式沒有關係? 這段可以Run沒有錯誤
推 commiserate:偵錯時 按Ctrl+Break可進入中斷模式
→ commiserate:按 F5 繼續 可以看說明檔 功能表中的偵錯項
推 ntcblin:請問我的程式有錯嗎
推 qsss:程式應該沒錯