Decided to go to the GoogleGroups site so that I can see the whole
discussion thread.
I'll explain in detail.
To create a change event:
Right-click on the sheet "tab"and select "View Code"
At the top of the editor "code" window is a set of pull-downs.
In the left pull-down, select "WorkSheet".
It will create a default selection change event:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
in the Right-hand pull-down, select "change"
It will create a worksheet Change event, you can put your code there:
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("b2").Value < Range("c1").Value Then
Range("b2").Value = Range("c1").Value
End If
If Range("b3").Value > Range("d1").Value Then
Range("b3").Value = Range("d1").Value
End If
End Sub
hope this helps
On Mar 5, 7:35 am, Paul Schreiner <schreiner_p...@att.net> wrote:
> You could:
> store initial values in a hidden cell.
> Create a change event for the worksheet
> that compares the cell contents to the hidden cells
> and update if the contents meet the criteria.
>
> (if a1 > H1 then H1 = a1)
> (if a2 < H2 then H2 = a2)
>
> let me know if you need help with the change events.
>
> Paul
>
> ________________________________
> From: Sach1810 <sach1...@googlemail.com>
> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
> Sent: Fri, March 5, 2010 3:39:40 AM
> Subject: $$Excel-Macros$$ Please help me print a the highest number that
> appears from a cell with continuously streaming data
>
> Hi,
>
> I have two cells lets say a1 and a2 both of which are continually
> updating from a live feed. I would like to be able to track what the
> highest number of a1 has been and what the lowest number of cell a2
> has been.
>
> Your help would be much appreciated as I am new to programming
>
> Many Thanks
>
> Sacha David
>
> --
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links
> :http://twitter.com/exceldailytip
> 2. Join our Facebook Group @http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
