Double click on an excel cell automatically at fixed intervals

[eugeneaeria]

Hi everyone

I need to double click (left button click) on a cell which allows it to import data automatically and refresh the data I am importing. How do I carry this out in an auto mode and at a fixed interval.

Then I would like to sample a cell with the data at fixed intervals too to populate a column, how do I carry this out.....


regards

Eugene

[xladept]

In your worksheet module you can insert the "Worksheet_BeforeDoubleClick" event and just call your code from that.

[eugeneaeria]

Hi xla....Sorry I do not understand......where is the worksheet module?

Joe

[xladept]

Hi Joe,

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
'your code here
End Sub

Press ALT + F11 to open the Visual Basic Editor.

Save your Workbook As Macro-Enabled

Click on your sheet

Type "Option Explicit" then paste the code under it

And, you should be ready to go

[eugeneaeria]

Attachment 270767
I am a novice at this...This is what I have done...what is the code
How does it click automatically every 5 seconds as an example
Also how do I do the next part which is to sample data from a ell at regular intervals too...