Thank you,
I am going to have a lot of questions in this and don't want people to have
to type out every answer. I was going to type out the question and then give
them 3 or 4 choices that they could just double click on. Then hopefully the
answer that they double clicked on would show up in a different cell to show
their answer.

"Gord Dibben" wrote:

If the user can d-click on an answer, then that answer must already be
there.

Why would you want it repeated?

I think your description needs refining, please post back.

But........yes, there is such an event as a double-click event that can
perform an action.


Gord Dibben MS Excel MVP


On Wed, 10 Dec 2008 13:39:03 -0800, ctefft
wrote:

I am setting up a questionnaire and I would like to set it up so that the
answer will fill in automatically after someone double clicks on the answer
that they want to use. Is there any way to set that up?