ExcelBanter - Double click in cell using VBA

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Double click in cell using VBA (https://www.excelbanter.com/excel-programming/330495-double-click-cell-using-vba.html)

Vuka

Double click in cell using VBA

I require to double click in a cell with VBA code. The excel help explain
the following: Worksheets("Sheet1").Activate
Application.DoubleClick
This however do not work.

Can someone help?

William Benson

Double click in cell using VBA

You need to select the range you are trying to double click, like

Worksheets("Sheet1").Activate
activesheet.range("A6").select

Then call Application.Doubleclick

"Vuka" wrote in message
...
I require to double click in a cell with VBA code. The excel help explain
the following: Worksheets("Sheet1").Activate
Application.DoubleClick
This however do not work.

Can someone help?

All times are GMT +1. The time now is 05:11 PM.