Selection Grid

[kirkm]

Once the following code has been executed -

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
As Boolean)
Dim sAddr As String
sAddr = "A184"
If Not Intersect(Target, Range(sAddr)) Is Nothing Then
Cancel = True
frmConfig.Show
End If
End Sub

.... the cell that was double clicked remains selected, with a black
grid showing.

Can this be turned off - by code?

Thanks - Kirk

 

[Guest]

The short answer is no. However, it can be moved to another cell. There
must be an active cell on the active sheet, so there is going to be a cell
with a black "grid" somewhere on the sheet. You can pick a cell to move it
to and simply use:

ChoiceCell.Active

With ChoiceCell being replaced with the actual cell reference.

 

[kirkm]

The short answer is no. However, it can be moved to another cell. There
must be an active cell on the active sheet, so there is going to be a cell
with a black "grid" somewhere on the sheet. You can pick a cell to move it
to and simply use:

ChoiceCell.Active

With ChoiceCell being replaced with the actual cell reference.

That sounds like it'll do nicely. Can you give me a example of usage,
please?

I tried "A1".Active and variations thereof without getting the right
syntax. And no help from F1.

Thanks - Kirk