看板 Office 關於我們 聯絡資訊
軟體: 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