Private Sub CommandButton1_Click()
Range("B9").Value = Evaluate("your sumproduct formula")
End Sub
--
Regards,
Tom Ogilvy
"Andyd74" wrote:
I am trying to retrieve data from a table on the push of a search button
where the selection is based on at least 2 criteria being selected and
then outputting this data in another cell. I.e. I want to retrieve the
total value from one column in the table where the "name" is "Andy" and
the "age" is "25".
I have this working using a normal SUMPRODUCT statement but i want this
to happen on the click of a button. So Can someone suggest some VBA code
that would allow me to do this.
Thanks
--
Andyd74
------------------------------------------------------------------------
Andyd74's Profile: http://www.excelforum.com/member.php...o&userid=34013
View this thread: http://www.excelforum.com/showthread...hreadid=537774