beforeDoubleClick (target, true)

M

mark kubicki

in a beforeDoubleClick procedure, i set the cancel arguement to true which
solves some wierd select/reselect problems that i was having;

however, when the user selects another cell, i want them to be able to use a
double click to initiate in-cell editing; however the beforeDoubleClick
procedure disabled it...

how (when the user selects a different cell that the double click target) do
i get it back on?
 
C

Chip Pearson

Mark,

You have to test the Target variable to determine if it is in the
range for which you want to disable double-click. For example,
the following code will disable double-click function in the
range A1:B10, and leave it to normal behavior in all other cells.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, _
Cancel As Boolean)
If Not Application.Intersect(Target, Range("A1:B10")) Is Nothing
Then
Cancel = True
End If
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
M

mark kubicki

if the target cell is later selected by click (not a doubleclick), will the
user then be able to double click within the active cell to edit the
contents (i would want them to be able to)?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top