Announcement

Collapse
No announcement yet.

Lock a Textbox from moving while scrolling

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    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, 14:23.

    Comment


    • #3
      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!

      Comment


      • #4
        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

        Comment


        • #5
          Re: Lock a Textbox from moving while scrolling

          You could place the textbox on a modaless useform.

          Cheers
          Andy

          Comment


          • #6
            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:

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


            Thanks

            ~jeff

            Comment


            • #7
              Re: Lock a Textbox from moving while scrolling

              What script?
              Hope that Helps

              Roy

              New users should read the Forum Rules before posting

              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.

              Comment


              • #8
                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, 14:35.

                Comment


                • #9
                  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.

                  Comment


                  • #10
                    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

                    Comment


                    • #11
                      Re: Lock a Textbox from moving while scrolling

                      By complicated I mean you appear to be making it so. It sounds more like a design problem.

                      Comment

                      Working...
                      X