Hi David,
I think placing the code in the Worksheet change event would help.
The event would be trigered as and when any cell on the sheet is
changed, and in the event it would revisit all your conditions that
are present in the code. Your code would look something like this.
Private Sub Worksheet_Change(ByVal Target As Range)
'****Highest Bid Price****
If Range("a2").Value < Range("a1").Value Then
Range("a2").Value = Range("a1").Value
End If
'****Lowest Offer Price****
If Range("b2").Value > Range("b1").Value Then
Range("b2").Value = Range("b1").Value
End If
'*****Lowest and highest LTP*****
If Range("c2").Value < Range("c1").Value Then
Range("c2").Value = Range("c1").Value
End If
If Range("c3").Value > Range("c1").Value Then
Range("c3").Value = Range("c1").Value
End If
End Sub
Cheers
Harpreet Gujral
On Mar 7, 7:51 pm, Sach1810 <sach1...@googlemail.com> wrote:
> Hi, I am currently using the following code, however I want this code
> to work continously when ever the numbers in row 1 change (these
> numbers change autimatically as they are a live feed referenced from
> another program). How can I make this continous?
>
> Sub Bid_Offer_Tracker()
> '****Highest Bid Price****
> If Range("a2").Value < Range("a1").Value Then
> Range("a2").Value = Range("a1").Value
> End If
> '****Lowest Offer Price****
> If Range("b2").Value > Range("b1").Value Then
> Range("b2").Value = Range("b1").Value
> End If
> '*****Lowest and highest LTP*****
> If Range("c2").Value < Range("c1").Value Then
> Range("c2").Value = Range("c1").Value
> End If
> If Range("c3").Value > Range("c1").Value Then
> Range("c3").Value = Range("c1").Value
> End If
> End Sub
>
> 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 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
