This should get you started:
http://www.mvps.org/dmcritchie/excel/event.htm

you would use target.column = 5 to check for column E
and target.column = 6 to check for column F

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
If Target.Column < 5 Or Target.Column 6 Then Exit Sub
Cells(Target.row, 7) = Target.Column
End Sub

to install right click on the sheet tab, view code
place the code under the Option Explicit
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"BB" wrote in message ...
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.