I am not really familiar with VB used in Excel, but in VB and in Access VB you have an "ON Click" event for buttons. You can put the code of what you want it to do there. (When the button is pressed, do something)

sub button1_Click()
  code goes here
end sub