Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word Wrap Not Working on Double Click | Excel Discussion (Misc queries) | |||
double-click mouse button not working | Excel Discussion (Misc queries) | |||
Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
excel file association (double click) not working ! | Setting up and Configuration of Excel | |||
Mouse Over Graph, Capture Information on Click(Double Click) | Excel Programming |