Programming double click functionality

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form in Excel my boss wants to use in a presentation. The form has two main tables and he wants to double click on a line item in one table and have it transfer to the other table and vise-versa. Is there some way to program that kind of function to a double click? In the visual basic editor, maybe? How else could I do accomplish the same thing and make my boss happy?
 
Hi Cyberindio

You can use this event in the Sheet module

This is working for column A and B

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Column = 1 Then
Target.Offset(0, 1).Value = Target.Value
End If
If Target.Column = 2 Then
Target.Offset(0, -1).Value = Target.Value
End If
End Sub




--
Regards Ron de Bruin
http://www.rondebruin.nl


Cyberindio said:
I have a form in Excel my boss wants to use in a presentation. The form has two main tables and he wants to double click on a line
Click to expand...
item in one table and have it transfer to the other table and vise-versa. Is there some way to program that kind of function to a
double click? In the visual basic editor, maybe? How else could I do accomplish the same thing and make my boss happy?
 
Back
Top