![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
VBA-Excel
conh22
这个作者很懒,什么都没留下…
展开
-
[VBA] Implied Volatility of American Option - Secant Method + Crank Nicholson
=========================================================================Public Function impVol(OptPrice As Double, S As Double, T As Double, x As Double, r As Double, Tol As Double) As Double======原创 2009-10-23 04:15:00 · 3082 阅读 · 0 评论 -
[VAB] txt reader -from Chirstina
Private Sub cmdImport_Click()Dim FldName() As String, FldStart() As Integer, FldEnd() As Integer, FldType() As String, _ FldFmt() As String, FldOFmt() As String, FldNoMulti() As StringDim wkbk As原创 2009-10-23 05:05:00 · 898 阅读 · 0 评论 -
Excel 小技巧
<br />自定义函数不能自动更新数据<br />用VBA编写的自定义函数,若调用的某单元数据被修改,是不会自动更新自定义函数值的。<br />如果使用了定义名称,可在名称中增加一个now()函数借用它的刷新功能:<br />如果名称是一个数值:x=row()*2+now()*0<br />如果名称是一个字符型数据:x=a1&a2&t(now())<br />这样,你的自定义函数的单元格内容就会自动刷新了。这里的now()函数并不是一定的,可以用其他VBA函数代替。原创 2010-10-27 21:37:00 · 1259 阅读 · 0 评论