軟體:
Excel 2003 SP3
我想請問一下,
我錄製了一個規劃求解的巨集。
就是想用一個按鈕指定這一個巨集,
這樣的話,就能直接在表單上面按按鈕來規劃求解。
但是我發現,好像沒辦法這樣做,
按下去之後,
他會寫說,有個SUB沒有定義...
這該怎麼辦啊...囧
功能表的功能都沒辦法用巨集來製作嗎?
Sub Macro4()
'
'
SolverOk SetCell:="$AH$2", MaxMinVal:=1, ValueOf:="0",
ByChange:="$AF$4:$AF$30"
SolverSolve
End Sub
--
"Every kid who has dreamed of being a baseball player has stood in his front
yard with a bat and said to himself, "Bottom of the ninth, Game 7 of the
World Series, the bases are loaded," and then envisioned hitting a home run
to win the game. My job is to shatter that dream."
By Huston Street
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 123.194.88.67