Help Getting Macro Button Work

Question

I just created a button to launch a Macro that runs the solver. But when I click it, it doesn't run. I see it click, but no action occurs. The VBA code behind the macro is very simple:

Sub SolveSurfaceTemp()

'

' SolveSurfaceTemp Macro

' Solves for Windbox Surface Temp (B7) after Windbox Temperature (B4), Ambient Temperature (B5) and Insulation Thickness (B9) have been input.

'

' Keyboard Shortcut: Ctrl+t

'

SolverOk SetCell:="$B$11", MaxMinVal:=3, ValueOf:=0, ByChange:="$B$7", Engine:= \_ 

    1, EngineDesc:="GRG Nonlinear" 

SolverOk SetCell:="$B$11", MaxMinVal:=3, ValueOf:=0, ByChange:="$B$7", Engine:= \_ 

    1, EngineDesc:="GRG Nonlinear" 

SolverSolve 

End Sub

I've confirmed that the macro works when I run it manually. I've enabled everything I know how, but I still can't launch the Solver from this button. Does anyone have a clue what might be wrong?

Answer 1

Re: "the macro works when I run it manually"

You may be using an ActiveX control, which takes some additional work to make it function.

Try using a Forms Control button

.

'---

Nothing Left to Lose

https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU

(free excel programs)

Answer 2

Yup! That solved the problem! Thx.

You are welcome.

'---

Nothing Left to Lose

Answer 3

Yup! That solved the problem! Thx.