How can I create a form control within a macro?

[zaser]

I made an excel add-in that creates a report from a site automatically.

I would like to add a form control to that report linked to another sub in the add-in file automatically.

This is so the user can run another report just by entering a value in a specific cell and pressing the form control.

RightMostColumnOfReport		Enter Date
RightMostColumnOfReport		"Value they Enter"
RightMostColumnOfReport		Form Control Button

<tbody>
</tbody>

Let me know if anything isn't clear