PDA

View Full Version : Is it possible at all?



bakunet
05-26-2016, 10:00 AM
Hi there.
I am coming to you with some issues.

I receive feed of some data that it is refreshed every 1-3s. Feed can be placed in excel cell using some special formula, and it is refreshed automaticly by the software.

Issue 1) Is it possible to save this feed as a number in separate different cell, that it will be not changed anymore with next refreshment of the feed?

Issue 2) Is it possible to make action from issue 1) every (x) seconds in another row, automaticly?

If yes, how to do it?

Thank you in advance for your help.

EDIT: please check image:

https://i.imgsafe.org/a0cdaea.jpg

snb
05-26-2016, 12:15 PM
crossposted at:

http://www.thecodecage.com/forumz/showpost.php?p=1055012751&postcount=1

SamT
05-26-2016, 03:02 PM
What is multiposting? (http://www.vbaexpress.com/forum/faq.php?faq=new_faq_item#faq_new_faq_item3)




Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target Is Range("B2") Then Range("C1").End(xlDown).Offset(1) = Target
End Sub