Consulting

Results 1 to 6 of 6

Thread: Change the amount of characters to appear on the status bar

  1. #1

    Change the amount of characters to appear on the status bar

    Hi would anyone know how you could change the limit on the amount of characters to appear on the status bar?

    I currently have an

    Application.StatusBar = "....Quite a few characters will appear here..."

    I can't shorten them as they are necessary here.

    If it means changing something in the registry so be it!

  2. #2
    Knowledge Base Approver VBAX Master Oorang's Avatar
    Joined
    Jan 2007
    Posts
    1,135
    Location
    I'm not sure if this is what you mean but you could truncate the text to the status bar like this:

    [VBA] Application.StatusBar = Left$("....Quite a few characters will appear here...",25)[/VBA]
    Cordially,
    Aaron



    Keep Our Board Clean!
    • Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
    • Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.

  3. #3
    Thanks for that but it looks like it only contains 130 spaces altogether,

    I have to fit in 160, i know it sounds a lot but there is still plenty of room on the status bar. If i go over 130 it will only display those 130.

    There probably isn't any way around it.

  4. #4
    VBAX Wizard
    Joined
    May 2004
    Posts
    6,713
    Location
    Interesting. I rarely ever use the Statusbar, as I have found people do not look at it.

    It depends on your screen resolution for one thing. If you reduce the resolution, you get less characters.

    That being said, I can get up to a maximum of 140 characters regardless of resolution. I can find no information on the length of characters that will display. It does not show up on the Limitations of Word listing.

  5. #5
    Knowledge Base Approver VBAX Master Oorang's Avatar
    Joined
    Jan 2007
    Posts
    1,135
    Location
    oh! I misunderstood what you wanted. I don't think you can without completly replacing it. And to do that you would have to use the API (read: pain in the neck). I'd suggest just making a form that has a Status Bar object and a textbox that will display the status while the program is running.
    Cordially,
    Aaron



    Keep Our Board Clean!
    • Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
    • Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.

  6. #6
    VBAX Wizard
    Joined
    May 2004
    Posts
    6,713
    Location
    Bingo!

Posting Permissions

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