- 博客(4)
- 收藏
- 关注
转载 Can the msgbox vbYesNo button captions be changed in VBA?
Private sButton1 As StringPrivate sButton2 As StringPrivate sCaption As StringPrivate sText As StringPrivate Const MB_ICONQUESTION As Long = &H20&Private Const MB_OKCANCEL As Long = &H1&Private Const
2007-12-06 00:31:00 3180
原创 Colour unique formulae and constant cells of all sheets of activeworkbook
A question in http://www.mrexcel.com/board2/viewtopic.php?t=304750I am looking for a macro which does two things: 1. colours all constants in a workbook as yellow. 2. colours all formulae with purpl
2007-12-06 00:16:00 1037
原创 Do you know how many combinations to select n numbers from 1 to m with sum of which is mysum?
Do you know how many combinations to select n numbers from 1 to m with sum of which is sum?Sub getit()Dim m&, n&, mysum&, i&, j&, k&, count()m = 100: n = 30: mysum = 700ReDim count(m, n, -mysum T
2007-12-03 00:37:00 1656
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人