Ironman
Well-known Member
- Joined
- Jan 31, 2004
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
Hi
The below code opens the general search box when I double click a defined cell.
I want to make this more specific so I just get a dialog box to enter d/mm/yyyy and then search Column A (although the above code does the job, it's not specific to Column A so I don't know if it's necessary to specify Column A with what I want to do now?).
Help appreciated, many thanks.
The below code opens the general search box when I double click a defined cell.
VBA Code:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Column = 1 And Target.Row = 11 Then
Application.Dialogs(xlDialogFormulaFind).Show
End If
End Sub
I want to make this more specific so I just get a dialog box to enter d/mm/yyyy and then search Column A (although the above code does the job, it's not specific to Column A so I don't know if it's necessary to specify Column A with what I want to do now?).
Help appreciated, many thanks.
Last edited: