Hi Les,
I have a modeless UserForm which opens on a DoubleClick event -
working fine. How can I do this but have the focus remain with the
ActiveCell? Or, alternatively, have the focus leave the newly
opened UserForm?
Presumably you're cancelling the BeforeDoubleClick? If so, one
solution is to specifically reactivate the Excel window:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
As Boolean)
UserForm1.Show vbModeless
AppActivate Application.Caption
Cancel = True
End Sub
Regards
Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk