Double click in cell using VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You need to select the range you are trying to double click, like

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

Then call Application.Doubleclick
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

doubleclick mrehod 2
VBA Countif across sheets? 5
DoubleClick mystery 2
Excel VBA help: Text file formatting 19
Excel VBA 0
Excel VBA 1
"Double Click" macro? 3
MS Excel VBA Pivot table link cell fetch records 1

Back
Top