Double Click event, but only for 1 column

**JP Romano** · 11-02-2010, 09:31 AM

Good day all,
I tried doing some searches for this, but haven't been able to come up with anything useful, so I figued I'd come back to the experts for some guidance.

I'm currently using a very simple beforedoubleclick event in one of my sheets to initiate another macro which launches and fills out a form. Right now, though, the form is launched from anywhere the user double clicks on the sheet ... I'd like to limit that to a specific column - so the code below will run ONLY if the user double clicks a cell in column D.

Not sure if it's relevant or not, but the spreadsheet has about 800 rows and 20 columns. The data in each row represents a small portion of the data contained on another hidden tab. When the user double clicks, a form opens with additional details from that other tab.

Thanks for any help, and I know it's not much to go by, but here's what I'm using for the double click.

Please Login or Register  to view this content.

**romperstomper** · 11-02-2010, 09:40 AM

Something along the lines of:

Please Login or Register  to view this content.

**JP Romano** · 11-02-2010, 10:04 AM

Absolutely perfect... thank you!

**joanathan1980** · 02-21-2014, 07:18 AM

hi,

this can be alsow helpful:

'this statement will restrict double click event to occur if the user doubleclick a cell that is not on column A
If Target.Column <> 1 Then
Cancel = False
Exit Sub
End If

'the res of the code...