Excel – Run Macro when Cell Clicked

I have a macro that opens a calendar control and enters the date chosen into the cell you’re in when you run the macro. I want the macro to run as soon as the cell is clicked. There are 6 worksheets and some have more than one cell where i’d want this to happen. Can anyone help? Thanks so much.