Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Page 1 of 2 1 2 LastLast
Results 1 to 10 of 11

Thread: Lock a Textbox from moving while scrolling

  1. #1
    Join Date
    30th June 2006
    Posts
    146

    Lock a Textbox from moving while scrolling

    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

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,713

    Re: How to lock a Textbox from moving ?

    Jeff, please don't use superfluous words like "How to" in Thread Titles
    Last edited by Dave Hawley; August 14th, 2006 at 14:23.

  3. #3
    Join Date
    22nd January 2004
    Location
    Colorado Springs
    Posts
    3,977

    Re: Lock a Textbox from moving while scrolling

    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!!!
    Regards,
    Barry

    My Favorite New Thing:
    Dynamic Named Ranges



    The alternative for
    "Press Any Key To Continue."

    and we all have one we'd like to use it on


    1. Cross Posting Etiquette
    2. Are You Here To Learn: What Have You Tried?
    3. Your Best Resource to begin learning VBA: RECORD A MACRO . . . Then Study It!

  4. #4
    Join Date
    30th June 2006
    Posts
    146

    Re: Lock a Textbox from moving while scrolling

    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

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,310

    Re: Lock a Textbox from moving while scrolling

    You could place the textbox on a modaless useform.

    Cheers
    Andy


  6. #6
    Join Date
    30th June 2006
    Posts
    146

    Re: Lock a Textbox from moving while scrolling

    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:

    VB:
    Private Sub Worksheet_SelectionChange(ByVal Target As Range) 
         
    End Sub 
    
    
    How can i apply this to the textbox within the Userform?


    Thanks

    ~jeff

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,137

    Re: Lock a Textbox from moving while scrolling

    What script?
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

  8. #8
    Join Date
    30th June 2006
    Posts
    146

    Re: Lock a Textbox from moving while scrolling

    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
    Last edited by Jeff P; August 15th, 2006 at 14:35.

    Excel Video Tutorials / Excel Dashboards Reports


  9. #9
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,713

    Re: Lock a Textbox from moving while scrolling

    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.

  10. #10
    Join Date
    30th June 2006
    Posts
    146

    Re: Lock a Textbox from moving while scrolling

    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

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Replies: 6
    Last Post: June 17th, 2008, 11:51
  2. Validate TextBox Before Moving to Next
    By Arthur494 in forum EXCEL HELP
    Replies: 5
    Last Post: June 22nd, 2007, 15:05
  3. Replies: 6
    Last Post: June 12th, 2007, 17:13
  4. Lock Textbox From Being Changed
    By AaronC in forum EXCEL HELP
    Replies: 2
    Last Post: December 19th, 2006, 08:10
  5. moving certain text from one textbox to another
    By katerina in forum EXCEL HELP
    Replies: 5
    Last Post: October 21st, 2005, 23:43

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno