Macro Help Private Sub Sheet_Selection_Change

[BIGTONE559]

I need help with a macro. I have a sheet_selection_change macro defined but it wont run because i have another macro that is inserting values in the sheets via code.

e.g.

sheet1 is supposed to enter a 1 in A1 when something is changed (sheet selection change)

i run a macro that enters data in B2 on sheet1 but the change doesn't register?


Please Help

 

[Norie]

If you want to monitor for a change you should use the Change event not the SelectionChange.

 

[BIGTONE559]

If you want to monitor for a change you should use the Change event not the SelectionChange.

Worked out perfect Norie thanks for the tip