AutoFill a cell with a value

  • Thread starter Thread starter N1KO
  • Start date Start date
N

N1KO

Hi,

I need to automatically fill a cell with a value from another cell once the
other cell is selected.

I have a list of numbers in column F and I need cell H2 to equal which ever
cell is selected or even double clicked (if that's possible).

Is there any way of doing this?

Thanks in advance
 
Install this event macro:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Cancel = True
If Target.Column = 6 Then Range("H2") = Target
End Sub

Regards,
Stefi

„N1KO†ezt írta:
 
Back
Top