{"id":2694,"date":"2022-11-01T11:59:21","date_gmt":"2022-11-01T03:59:21","guid":{"rendered":"http:\/\/cnliutz.uicp.io\/?p=2694"},"modified":"2022-11-01T11:59:21","modified_gmt":"2022-11-01T03:59:21","slug":"vba%e8%b0%83%e7%94%a8excel%e5%87%bd%e6%95%b0","status":"publish","type":"post","link":"http:\/\/i10bu9ku.ipyingshe.net:5347\/?p=2694","title":{"rendered":"VBA\u8c03\u7528excel\u51fd\u6570"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>Sub InsertFormula()\n Worksheets(\"Sheet1\").Range(\"A1:B3\").Formula = \"=RAND()\"  'a1\uff1ab3\u5355\u5143\u683c\u5185\u4ea7\u751f\u968f\u673a\u6570\n    '-----\u8ba1\u7b97\u8d37\u6b3e\u5229\u7387  \u8d37\u6b3e89000\uff0c\u5229\u7387\uff1a4.7%\uff0c\u5e74\u9650\uff1a20\uff0c<strong>\u7ed3\u679c<\/strong>\uff1a572.71\u5143\/\u6708------------\n    Static loanAmt\n    Static loanInt\n    Static loanTerm\n    loanAmt = Application.InputBox _\n     (Prompt:=\"Loan amount (100,000 for example)\", _\n     Default:=loanAmt, Type:=1)\n    loanInt = Application.InputBox _\n     (Prompt:=\"Annual interest rate (8.75 for example)\", _\n     Default:=loanInt, Type:=1)\n    loanTerm = Application.InputBox _\n     (Prompt:=\"Term in years (30 for example)\", _\n     Default:=loanTerm, Type:=1)\n    payment = Application.WorksheetFunction _\n     .Pmt(loanInt \/ 1200, loanTerm * 12, loanAmt)\n    MsgBox \"Monthly payment is \" &amp; Format(payment, \"Currency\")\nEnd Sub\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2694","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/i10bu9ku.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts\/2694","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/i10bu9ku.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/i10bu9ku.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/i10bu9ku.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/i10bu9ku.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2694"}],"version-history":[{"count":0,"href":"http:\/\/i10bu9ku.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts\/2694\/revisions"}],"wp:attachment":[{"href":"http:\/\/i10bu9ku.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2694"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/i10bu9ku.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2694"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/i10bu9ku.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2694"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}