+ Reply to Thread
Results 1 to 7 of 7

Floating Text Box

  1. #1
    Forum Contributor
    Join Date
    01-20-2014
    Location
    Greece
    MS-Off Ver
    20 yr. old Excel 2002!
    Posts
    710

    Floating Text Box

    Is there a way for a text box to be always visible in a worksheet as one scrolls vertically and horizontally?

    I have tried this code but it does not work (Also I am not sure about the text box name (TextBox1) as is not visible in object's properties)

    Please Login or Register  to view this content.

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Floating Text Box

    Good morning drgkt

    Not with a textbox, no. It's fixed to the cells.

    You could achieve the effect you're after with a userform, though.
    Set the form up, and in the properties, set ShowModal to false.

    HTH

    DominicB

  3. #3
    Forum Contributor
    Join Date
    01-20-2014
    Location
    Greece
    MS-Off Ver
    20 yr. old Excel 2002!
    Posts
    710

    Re: Floating Text Box

    Hmmm... Not familiar with that. Could you point me in the right direction?
    Thanks

  4. #4
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Floating Text Box

    Works fine for me with an ActiveX Textbox.
    Attached Files Attached Files
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  5. #5
    Forum Contributor
    Join Date
    01-20-2014
    Location
    Greece
    MS-Off Ver
    20 yr. old Excel 2002!
    Posts
    710

    Re: Floating Text Box

    See error
    Note I am using Excel for XP (2002).
    Can you post an XLS file?


    EDIT: Whatever might be the solution, form or textbox, can it be shown ONLY on a specific sheet of the workbook?
    Attached Images Attached Images
    Last edited by drgkt; 09-28-2017 at 07:24 AM.

  6. #6
    Forum Contributor
    Join Date
    01-20-2014
    Location
    Greece
    MS-Off Ver
    20 yr. old Excel 2002!
    Posts
    710

    Re: Floating Text Box

    Any updates please?

  7. #7
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Floating Text Box

    Khalispera.


    I am with Dominic.

    Create a Userform with a single textbox

    Open and close the the userform using the code below.
    Right Click on the sheet name at the bottom of excel and select view code to see the code.


    Please Login or Register  to view this content.

    Select Sheet1 then Sheet2 then Select Sheet1 then Sheet2
    Attached Files Attached Files
    Last edited by mehmetcik; 09-30-2017 at 01:24 PM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. floating text box when scroll
    By NYBoy in forum Excel General
    Replies: 4
    Last Post: 05-18-2020, 09:30 AM
  2. Creating a Floating Text Box
    By MatthewIJClark in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-19-2014, 11:41 AM
  3. Floating Text Box
    By MatthewIJClark in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-14-2013, 11:45 AM
  4. How to add a floating text box in 2007
    By zhuowang1980 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-24-2013, 03:54 PM
  5. Creating a floating text box containing a hyperlink
    By Gti182 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-01-2013, 10:26 AM
  6. Floating Text Box
    By Phil Walters in forum Excel General
    Replies: 3
    Last Post: 11-12-2012, 06:06 AM
  7. [SOLVED] How do I add a floating text box in Excel?
    By Prashant in forum Excel General
    Replies: 1
    Last Post: 09-27-2005, 09:05 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1