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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]RightMostColumnOfReport[/TD]
[TD] [/TD]
[TD="align: center"]Enter Date[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]RightMostColumnOfReport[/TD]
[TD][/TD]
[TD="align: center"]"Value they Enter"[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]RightMostColumnOfReport[/TD]
[TD][/TD]
[TD="align: center"]Form Control Button[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Let me know if anything isn't clear