Results 1 to 3 of 3

Thread: Access the excel statusbar

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Oct 2013
    Posts
    30

    Access the excel statusbar

    Hi,

    Apologies if this is in the wrong forum and if it is would appreciate a mod moving it. Thanks.

    Longish post warning!!

    This is a multipart sort of question from a newbie to vbforums. I've been using VBA for some time now and am comfortable with using APIs. Possibly not series of them where they may need to be called in sequence and so on but anyroad....

    My original question then. Using the statusbar as a progress bar is a well known, documented, and accepted method of displaying.. well.. progress.
    I'm unhappy with the way when posting messages via Application.StatusBar, a proportional font is used. It quite often makes reading the progress not such an easy thing to do because the length of text changes so much.

    So I started out to change the font of the excel statusbar to a non proportional one. Easy you say. Piece of cake you say. I'd suggest trying it. I've come to the opinion that the excel application.statusbar is an extra window built on top of the actual statusbar. Also that it seems different to most other application statusbars. I could actually add a statusbar object and use that but I can't get it to cover the real statusbar like application.statusbar does.

    This will I'm sure involve the API hence my posting here.

    Now then.. During my research on this and coming upon this site I thought it would be useful to use VB and visual studio instead of VBA. I duly downloaded VS 19, the latest I could find free, downloaded a VBP from vbforums - howto_get_listbox_choices , opened it and tried to run it. HOW DO I DO THAT PLEASE!!??

    I feel I'm missing something fundamental and have noooo idea what it is! If someone has a link to explain it all I would be very grateful.

    Many thanks In Advance
    Lisa

  2. #2
    Frenzied Member jdc2000's Avatar
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    1,810

    Re: Access the excel statusbar


  3. #3

    Thread Starter
    Junior Member
    Join Date
    Oct 2013
    Posts
    30

    Re: Access the excel statusbar

    Hi jdc,

    Weeeelllll.. not really. They both sort of depend on "padding" out the string to a certain length which isn't what I was looking for. There are multiple posts on the net about doing this and it's really messy deciding which proportional characters to fill out the padding with. You can't just change the font at all. The closest I've come so far is to use a text box on a not visible form. The text box wll expand with the text you put in it. When it's a specific length you can use that text in the statusbar. It's not a very satisfactory solution. I was looking to alter the font in the statusbar. A side effect is that if I can alter the font I can alter the colour as well which is a bonus to make it more noticeable. In any case I'm hooked now! I want to know why I can't change the font!!!

    Lisa

Posting Permissions

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



Click Here to Expand Forum to Full Width