SolverOk Function To Automate Upon The Click Of A Button

I'm using the SolverOk function to automate upon the click of a button. The arguement ValueOf takes the value (58.6) that was keyed into the Solver Parameter menu when I was recording the macro. I'd like the the solver to pick up the figure for ValueOf:= from cell $D$32 instead so that I can just key in any value in $D$32 and then click on the button to get solver to solve for this. I've tried modifying ValueOf:= "$D$32" but the solver still could not pick up the figure from that cell.

Private Sub CommandButton1_Click()
Range("C32").Select
SolverOk SetCell:="$C$32", MaxMinVal:=3, ValueOf:=58.6, ByChange:="$C$33"
SolverSolve

End Sub

End Sub