One way would be to use the worksheet doubleclick event. Right click the
sheet tab, select view code and paste the following event code:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range _
, Cancel As Boolean)
On Error GoTo Exit_Event
Application.EnableEvents = False

If Target.Count = 1 Then
If Target.Column = 5 Or Target.Column = 6 Then
Cells(Target.Row, 8).Value = Target.Value
End If
End If
Cancel = True

Exit_Event:
Application.EnableEvents = True
End Sub

Hope this helps
Rowan

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.