+ Reply to Thread
Results 1 to 4 of 4

Floating Text Box

  1. #1
    Registered User
    Join Date
    08-30-2007
    Posts
    82

    Floating Text Box

    Hi guys

    I have a spreadsheet which has a number of rows frozen at the top and a few rows and columns hidden. I am adding information dependent on late deliveries but would like to add a "floating" text box if possible which would stay in the same place when i scroll down to view the inputted data. The box will contain actions carried out for the reasons behind the lateness so they are always on view.

    Is this possible please?

    PhilDespatch Late Log.xlsm

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,168

    Re: Floating Text Box

    Can't you put it in your frozen rows?

  3. #3
    Registered User
    Join Date
    08-30-2007
    Posts
    82

    Re: Floating Text Box

    Hi Kyle

    i could do yes but as time goes on the text box will populate which will force me to expand my frozen area. Unless of course i could enable a scroll bar on it. Is that a possibility?

    Many thanks

    Phil

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,168

    Re: Floating Text Box

    Yes, you could do that, though I don't think that you can have a forms textbox with a multi-line property so you'd have to use an ActiveX one which I wouldn't recommend (ActiveX controls on worksheets can get up to all sorts of naughtiness).

    The other option would be to have a userform, userforms float so stay where they are on the screen regardless of where you scroll in the workbook.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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