Trigger Macro By Slecting Cell

[MikeG]

I know how to trigger a macro when a Cell's value changes, but can a macro be triggered simply by selection of a cell? If so, what is the code?

Thanks,

MikeG

 

[MikeG]

Sorry, one last question:

Is it possible to set a user form so that it closes when the user selects any cell in the worksheet? In other words the user form does not need to be closed by taking an action that involves the user form itself, it that makes sense.

Thanks

 

[Kenneth Hobson]

Please start a new thread for a new question that does not relate to the current thread.

 

[MikeG]

Please start a new thread for a new question that does not relate to the current thread.

Will do. I did think about it, and thought it was generally related in terms of cell selection and user form display, but is a bit of a stretch!