I have been seeking a way to transfer control to another worksheet, Bring
data along and populate that worksheet with a single click of the mouse. It
appears as though ON.DOUBLECLICK may do the job, albeit with a double click.

Can someone direct me to more information on how to use the function, all my
sources bo not give me sufficient data to use it as I am a beginning user of
macros.

Any help or clarification will be appreciated.

Craig