View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
baxybaxy
 
Posts: n/a
Default Can I create a display box to see results no matter where I am in


not elegant, but you could insert a blank chart; add some text boxes to
the chart to point to your data (click on the chart background
anywhere, type = and point to your cell)

then unforunately you need a bit of VBA code to move the chart to the
top left of the window every time you scroll around

try this one for a start point
http://www.ozgrid.com/VBA/limit-scrolling-vba.htm


--
baxybaxy
------------------------------------------------------------------------
baxybaxy's Profile: http://www.excelforum.com/member.php...o&userid=35824
View this thread: http://www.excelforum.com/showthread...hreadid=555809