Would this be a good place to use Data Validation?:
That would put both options on a drop-down list. The user would then just
pick one of the items and it would be selected.

Select the option cell
DataData Validation
Allow: List
Source: Option1, Option2 (just type in the items separated by commas.)
Click OK

Does that help?

***********
Regards,
Ron


"BB" wrote:

Hey I am trying to design a small spreadsheet in which you have a choice
between two options, one in column E and one in column F. Is there a way in
VBA to make it possible to double click on the choice that you pick and for
that choice to then show up in another column, H.

Is this too complicated and is there an easier way to do this? Thanks in
advance for your help.