Double Click a cell in Excel Macro

Help
1

Hi All,

I’m automating excel macro and I need to double click certain cells in macro. Upon double clicking the cell, a pop-up will open and I need to enter data in that pop-up. I can’t use click activities as there are no selectors for cells of macro.I have used f2 key, its allowing edit mode but double click action is not performed.Could anyone suggest any shortcut key for double clicking the cell.

2

Hi @manjusha.chandana,

Method 1: Execute Macro

Worksheets("Sheet1").Activate 
ActiveSheet.Range("F1").select
Application.DoubleClick

Method 2:
image