View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Atishoo Atishoo is offline
external usenet poster
 
Posts: 267
Default Keep text box visible

Hi Dave

Its a forms menu text box not an active x.

Was wondering if trigering it as mouse over might work while scrolling given
that cels move past the cursor while scrolling (though that of course would
necessitate the cursor being over the set worksheet area at the time).
Text box is originally named "Text Box 1"

thanks

"Dave Peterson" wrote:

Excel doesn't have any event for scrolling.

But you could reposition the textbox after you've changed the selection.

If that's ok,

What's the name of the textbox?
Was it from the Drawing toolbar or from the Control Toolbox toolbar?

===
Someone did post an API/MSIE object (I think) that did do this, but it was too
complex for me.


Atishoo wrote:

Hi all
Am wanting to keep a text box visible while scrolling, I cant use freeze
panes as I need the whole page to scroll behind a position locked text box.

I am thinking can i create a formula to trigger when scrolling that will
dynamically recalculate the "top" property of the text box to hold it in
position??


--

Dave Peterson
.