文章分类 - VBA
工作中用到的VBA编程
excel顶层显示
摘要：1 'Update 20140909 2 #If Win64 Then 3 Public Declare PtrSafe Function SetWindowPos Lib "user32" (ByVal HWND As LongPtr, ByVal hwndinsertafter As LongP
阅读全文
VBA计算两个三角形的交叠面积
摘要：
1 Public Function crossarea(Rx, Ry, Gx, Gy, Bx, By, RefRx, RefRy, RefGx, RefGy, RefBx, RefBy) As Variant 2 '色坐标赋值 3 Dim crossline(1 To 6, 1 To 7) As D
阅读全文
1 Public Function crossarea(Rx, Ry, Gx, Gy, Bx, By, RefRx, RefRy, RefGx, RefGy, RefBx, RefBy) As Variant 2 '色坐标赋值 3 Dim crossline(1 To 6, 1 To 7) As D
阅读全文
