Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_BeforeDoubleClick event question
Sometimes when I doubleclick on a cell, the cursur jumps to the cell below
the last used cell in the column. What can I do to prevent this? Thanks, Barb Reinhardt |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_BeforeDoubleClick event question
If in Tools / Options / Edit "Edit directly in cell" is checked (left)
double click will put the cell into input mode. Otherwise, left mouse double-click will select precedents (ie referenced cells in the formula). If there are no precedents double click would not do anything, assuming you don't hit the little + bottom right of the cell Regards, Peter T "Barb Reinhardt" wrote in message ... Sometimes when I doubleclick on a cell, the cursur jumps to the cell below the last used cell in the column. What can I do to prevent this? Thanks, Barb Reinhardt |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_BeforeDoubleClick event question
Nothing that I know of. When you are directly over the cell you get the
standard cursor. When you are over the border of the active cell you get the Move cursor (4 Arrows). Even on a double click the first click activates the cell. If the second click is associated with the move handle then the goto end is the standard actions and the double click is not assocated with the cell. Since I never use the goto end feature by double clicking it is really annoying for no particularily good reason. -- HTH... Jim Thomlinson "Barb Reinhardt" wrote: Sometimes when I doubleclick on a cell, the cursur jumps to the cell below the last used cell in the column. What can I do to prevent this? Thanks, Barb Reinhardt |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_BeforeDoubleClick event question
I'm specifically using the doubleclick event to do something and this
"feature" is particularly annoying. The only way I've found around it is to do this Application.CellDragAndDrop = FALSE 'On WorkBook_Open I HATE doing that, but it is what it is. Thanks for your help. Barb Reinhardt "Jim Thomlinson" wrote: Nothing that I know of. When you are directly over the cell you get the standard cursor. When you are over the border of the active cell you get the Move cursor (4 Arrows). Even on a double click the first click activates the cell. If the second click is associated with the move handle then the goto end is the standard actions and the double click is not assocated with the cell. Since I never use the goto end feature by double clicking it is really annoying for no particularily good reason. -- HTH... Jim Thomlinson "Barb Reinhardt" wrote: Sometimes when I doubleclick on a cell, the cursur jumps to the cell below the last used cell in the column. What can I do to prevent this? Thanks, Barb Reinhardt |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_BeforeDoubleClick event question
You hit the edge of the cell.
If you're more careful with your clicking (make sure you click inside the borders), you won't have the problem. Barb Reinhardt wrote: Sometimes when I doubleclick on a cell, the cursur jumps to the cell below the last used cell in the column. What can I do to prevent this? Thanks, Barb Reinhardt -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_BeforeDoubleClick event question
That's exactly it, but since I hit the edge of the cell about 20% of the time
once I figured out what was happening, it's not acceptable. I hate putting in workarounds like this, but we need a doubleclick event, more than we need the other functionality in this workbook. "Dave Peterson" wrote: You hit the edge of the cell. If you're more careful with your clicking (make sure you click inside the borders), you won't have the problem. Barb Reinhardt wrote: Sometimes when I doubleclick on a cell, the cursur jumps to the cell below the last used cell in the column. What can I do to prevent this? Thanks, Barb Reinhardt -- Dave Peterson |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_BeforeDoubleClick event question
I used to have the same problem.
I switched to de-caf and things got better <vbg. Barb Reinhardt wrote: That's exactly it, but since I hit the edge of the cell about 20% of the time once I figured out what was happening, it's not acceptable. I hate putting in workarounds like this, but we need a doubleclick event, more than we need the other functionality in this workbook. "Dave Peterson" wrote: You hit the edge of the cell. If you're more careful with your clicking (make sure you click inside the borders), you won't have the problem. Barb Reinhardt wrote: Sometimes when I doubleclick on a cell, the cursur jumps to the cell below the last used cell in the column. What can I do to prevent this? Thanks, Barb Reinhardt -- Dave Peterson -- Dave Peterson |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_BeforeDoubleClick event question
Oh great! I already drink decaf. I guess I'm up the crick! Thanks so much
for your help. <vbg back atcha "Dave Peterson" wrote: I used to have the same problem. I switched to de-caf and things got better <vbg. Barb Reinhardt wrote: That's exactly it, but since I hit the edge of the cell about 20% of the time once I figured out what was happening, it's not acceptable. I hate putting in workarounds like this, but we need a doubleclick event, more than we need the other functionality in this workbook. "Dave Peterson" wrote: You hit the edge of the cell. If you're more careful with your clicking (make sure you click inside the borders), you won't have the problem. Barb Reinhardt wrote: Sometimes when I doubleclick on a cell, the cursur jumps to the cell below the last used cell in the column. What can I do to prevent this? Thanks, Barb Reinhardt -- Dave Peterson -- Dave Peterson |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_BeforeDoubleClick event question
Once I started watching where I clicked/doubleclicked, then it actually got
easier to get it right. I bet you don't have the problem in a couple of days (or weeks or...) Barb Reinhardt wrote: Oh great! I already drink decaf. I guess I'm up the crick! Thanks so much for your help. <vbg back atcha "Dave Peterson" wrote: I used to have the same problem. I switched to de-caf and things got better <vbg. Barb Reinhardt wrote: That's exactly it, but since I hit the edge of the cell about 20% of the time once I figured out what was happening, it's not acceptable. I hate putting in workarounds like this, but we need a doubleclick event, more than we need the other functionality in this workbook. "Dave Peterson" wrote: You hit the edge of the cell. If you're more careful with your clicking (make sure you click inside the borders), you won't have the problem. Barb Reinhardt wrote: Sometimes when I doubleclick on a cell, the cursur jumps to the cell below the last used cell in the column. What can I do to prevent this? Thanks, Barb Reinhardt -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_BeforeDoubleClick event question
Figured it out... On Cell Select turn off drag and drop and use a ontime
event to turn it back on a couple of seconds later. Something like this... Private Sub Worksheet_SelectionChange(ByVal Target As Range) Application.CellDragAndDrop = False Application.OnTime Now + TimeSerial(0, 0, 3), "ResetDragAndDrop" End Sub Public Sub ResetDragAndDrop() Application.CellDragAndDrop = True End Sub Select fires before double click. It is not ideal but you do have drag and drop most of the time... -- HTH... Jim Thomlinson "Barb Reinhardt" wrote: I'm specifically using the doubleclick event to do something and this "feature" is particularly annoying. The only way I've found around it is to do this Application.CellDragAndDrop = FALSE 'On WorkBook_Open I HATE doing that, but it is what it is. Thanks for your help. Barb Reinhardt "Jim Thomlinson" wrote: Nothing that I know of. When you are directly over the cell you get the standard cursor. When you are over the border of the active cell you get the Move cursor (4 Arrows). Even on a double click the first click activates the cell. If the second click is associated with the move handle then the goto end is the standard actions and the double click is not assocated with the cell. Since I never use the goto end feature by double clicking it is really annoying for no particularily good reason. -- HTH... Jim Thomlinson "Barb Reinhardt" wrote: Sometimes when I doubleclick on a cell, the cursur jumps to the cell below the last used cell in the column. What can I do to prevent this? Thanks, Barb Reinhardt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Quick ? - Worksheet_BeforeDoubleClick | Excel Programming | |||
Worksheet_BeforeDoubleClick() | Excel Programming | |||
Worksheet_BeforeDoubleClick Stops Working | Excel Programming | |||
Worksheet_beforedoubleclick | Excel Programming | |||
Sub Worksheet_BeforeDoubleClick from elsewhere? | Excel Discussion (Misc queries) |