Trigger a macro by clicking in column B

[USAMax]

I have been righting macros for years but I have never written one with a trigger. I don't even know what to search for.

FUNCTION NEEDED
When some clicks on a cell in column B
° If the cell is blank I need a check mark and then to run the macro I have written.
° If the cell is not blank I need a check mark and then to run the macro I have written.

This should be simple and I know where to write the code for the sheet I just don't know how to trigger it. The only other question is what would happens if they select B2 through B6 or A2 through F2?

Thanks,

Dave

 

[AlphaFrog]

FUNCTION NEEDED
When some clicks on a cell in column B
° If the cell is blank I need a check mark and then to run the macro I have written.
° If the cell is not blank I need a check mark and then to run the macro I have written.

This should be simple and I know where to write the code for the sheet I just don't know how to trigger it. The only other question is what would happens if they select B2 through B6 or A2 through F2?

It looks like your "function needed" does the same thing for both blank and not blank cells?

What do you want done if select B2 through B6 or A2 through F2?

This would loop through each selected cell in column B and ignores selected cells in other columns.

[color=darkblue]Private[/color] [color=darkblue]Sub[/color] Worksheet_SelectionChange([color=darkblue]ByVal[/color] Target [color=darkblue]As[/color] Range)
    [color=darkblue]Dim[/color] cell [color=darkblue]As[/color] Range
    [color=darkblue]If[/color] [color=darkblue]Not[/color] Intersect(Range("B:B"), Target) [color=darkblue]Is[/color] [color=darkblue]Nothing[/color] [color=darkblue]Then[/color]
        [color=darkblue]For[/color] [color=darkblue]Each[/color] cell [color=darkblue]In[/color] Intersect(Range("B:B"), Target)
            [color=green]'do stuff here with the "cell" variable[/color]
        [color=darkblue]Next[/color] cell
    [color=darkblue]End[/color] [color=darkblue]If[/color]
End [color=darkblue]Sub[/color]

 

[USAMax]

Thank you AlphaFrog, you are right I did make a mistake. I need the cell cleared if it is not already blank. My macro will be looking to see if the cell is blank or not to decide the results of another sheet. You have given me everything I need, now all I need is a decent check mark. I found a few but I don't like any of them. I even considered the Square Root smble

FUNCTION NEEDED
When some clicks on a cell in column B
° If the cell is blank I need a check mark and then to run the macro I have written.
° If the cell is not blank I need the cell cleared and then to run the macro I have written.


Thank you again AlphaFrog!