Here's a pictorial representation of how to assign macro to a shape or form control in your worksheet.

Note: Shapes or form controls are NOT event-driven active-x controls.

Have A Macro In Workbook Module.jpgHave A Shape That You Want To Assign A Macro To.jpgSelect This Workbook In The Assign Macro Window And Select The Macro Name From The List Above.jpgYou Can Also Insert A New Macro - Excel Will Automatically Create A Sub-routine Name For You.jpgYou Can Call Your Macro In The Newly Created Sub-routine.jpg