Double-Click Function And Copy-Paste Value In Cell B2

[FLani]

Hi,

Cell B2 is a dropdown list of names. So is there a double click Function to copy and paste the value/name in B2 to the cell where i double-clicked it?

[:) Sixthsense :)]

Copy the below code and Do right click on sheet tab and select View Code and add it in the code window

Please Login or Register  to view this content.

[FLani]

The range of cells should come from column F only

[FLani]

your code is not copying cell b1 by double-click

[FLani]

i meant b2

[:) Sixthsense :)]

Please describe what wrong with the code for doing correction