Lock a Textbox from moving while scrolling

[Jeff P]

hello...

I know it's possible to lock objects (textboxes), via their properties. ( ie: to move or not with cells),

However, I'm trying to lock down a textbox so that when I scroll the main window, the entire page scrolls except the textbox, which remains in it's position.

A quick solution would be to freeze/split this area... but part of my work area is already utilizing a frozen partition.
I don't believe there is a way to freeze multiple areas.. or is there?


Any ideas how to prevent a textbox from moving?


Thanks

~Jeff

[Dave Hawley]

Jeff, please don't use superfluous words like "How to" in Thread Titles

[iwrk4dedpr]

Jeff,

Items that have the ability to scroll, except listboxes and the like, should have a scrolling event that you can utilize to set the top property of the text box.

It should be as simple as adding a fixed value to the items scrolltop property. Though I find that making this "floating" box is more of a hassle than it's worth!!!

[Jeff P]

Thanks for the info..

I do see the "top" value within the properties dialogue. However, this value is a fixed position.

In order to have an object remain motionless as i scroll through my worksheet, i would have to set up a code for the textbox " top" value, to coincide with the value of worksheet scrollbar.

Sounds complicated.

perhaps i'll find an alternative.

Thanks for the idea.

~jeff

[Andy Pope]

You could place the textbox on a modaless useform.

[Jeff P]

Thanks Andy

I've been trying to learn on this aspect of Excel.. Never knew this part was there.

I'm able to create a userform with a textbox and scrollbar. However when i run this, it becomes a separate console from Excel... how can I have this incorporated for my use?

I have this small script which inserts text from a cell into a textbox:

Private Sub Worksheet_SelectionChange(ByVal Target As Range) 
     
End Sub 

How can i apply this to the textbox within the Userform?


Thanks

~jeff

[royUK]

What script?

[Jeff P]

oops..

sorry,

I meant that i simply have the textbox linked to a cell, so that the contents appear within.

Can i set up this simple procedure with a userform? I don't see this option to link to a cell,



Basically, i have a single column of text headings, (A1: A50 ) which i'd like to link to a textbox ( one that doesn't move)
When i click in any cell, within column A, The contents appears in the textbox.



~jeff

[Dave Hawley]

Can't you just Freeze Panes at Column "A". Not sure what you aim here is but It sounds complicated and not worth the hassle.

[Jeff P]

Complicated,?

Certainly for me.. or perhaps my inexperience (confusion!) has given it this impression.

I've utilized the freeze pane option already. at row 6, for my upper heading. I don't believe there can be more than one zone that can freeze .


Perhaps i'm in over my head with Userforms.. I'll try do do more research.


Thanks

~jeff