Since my last post I have had to dip a toe in the VBA pond although at the moment it feels a bit more like an Ocean, but I am getting there.
Mojo249 was great and she helped no end with the conditional formatting problem I had but my requirements were wrong so although the worksheet worked perfectly i didnt really do what I need.
To condense the explanation I have enclosed the link from my last post
http://www.mrexcel.com/forum/showthread.php?t=430787
Here is the problem. As the realtime stock data changes, visually it looks like the wrong numbers are changing. I now want to have the current price move up and down the price scale visually by highlighting the current price. Then as the price moves off the screen or towards the top or bottom I can press a button to centre the current price on the screen.
I know I need to do this using Vba but this is a little advanced for me at this stage. can anyone offer any suggestions please.
Mojo249 was great and she helped no end with the conditional formatting problem I had but my requirements were wrong so although the worksheet worked perfectly i didnt really do what I need.
To condense the explanation I have enclosed the link from my last post
http://www.mrexcel.com/forum/showthread.php?t=430787
Here is the problem. As the realtime stock data changes, visually it looks like the wrong numbers are changing. I now want to have the current price move up and down the price scale visually by highlighting the current price. Then as the price moves off the screen or towards the top or bottom I can press a button to centre the current price on the screen.
I know I need to do this using Vba but this is a little advanced for me at this stage. can anyone offer any suggestions please.