LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 20
Default double click not working

Hello people!
I have a problem with a double click event:
Basically the following code works to start one of two macros (according to
which cell I double click)

Private Sub Worksheet_BeforeDoubleClick(ByVal _
Target As Range, Cancel As Boolean)
Dim dcCell As Range

If Target.Value 0 Then
Cancel = True
Else: Exit Sub
End If
If Target.Column = 1 Then
Call POtoContract(dcCell:=Target)
Else
If Target.Column = 4 Then
Call copytableline(cyCell:=Target)

End If
End If
End Sub

Now at one point in the "called" macro the user is asked to input a name, if
he spells the name wrong a message box warns the user and then the sub exits.
After that if I try to double click again it goes into editing and ignores
the double click event macro until I restart the workbook.
Does anyone know what is wrong?
Thanks for any help,
Joe.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word Wrap Not Working on Double Click redshift Excel Discussion (Misc queries) 1 April 1st 10 01:13 AM
double-click mouse button not working squeezerfan Excel Discussion (Misc queries) 0 November 6th 06 09:28 PM
Click on graph bar to execute a double-click in a pivot table cell [email protected] Charts and Charting in Excel 4 August 3rd 05 01:37 AM
excel file association (double click) not working ! Nick Calladine Setting up and Configuration of Excel 3 June 6th 05 06:43 PM
Mouse Over Graph, Capture Information on Click(Double Click) Dean Hinson[_3_] Excel Programming 1 December 6th 04 04:49 AM


All times are GMT +1. The time now is 01:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"