What's the VB syntax for determining the current row and current col prior to a DoubleClick?
Thanks
k483
What's the VB syntax for determining the current row and current col prior to a DoubleClick?
Thanks
k483
If you mean the cell in which the double click occurred, then one way:
Private Sub Worksheet_BeforeDoubleClick( _
ByVal Target As Excel.Range, Cancel As Boolean)
With Target
MsgBox "Address: " & .Address & vbNewLine & _
"Row: " & .Row & vbNewLine & _
"Column: " & .Column
End With
End Sub
Put the code in the Worksheet code module.
In article <[email protected]>,
k483 <[email protected]> wrote:
> What's the VB syntax for determining the current row and current col
> prior to a DoubleClick?
Sub Macro1()
i = Selection.Row
j = Selection.Column
MsgBox (i)
MsgBox (j)
End Sub
If you have Selected a single cell
--
Gary's Student
"k483" wrote:
>
> What's the VB syntax for determining the current row and current col
> prior to a DoubleClick?
>
> Thanks
>
>
> k483
>
>
> --
> k483
> ------------------------------------------------------------------------
> k483's Profile: http://www.excelforum.com/member.php...o&userid=10791
> View this thread: http://www.excelforum.com/showthread...hreadid=488215
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks