Share via

Userform statusbar control

Anonymous
2011-01-16T18:04:49+00:00

Hi all,

Among the controls for userforms is statusbar control. I couldn't figue it out how to display any message on this control. Anyone has a idea how to use statusbar control on a userform?

Note : I'm not talking about

Application.StatusBar = "something ...."

but the control on a userform.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Jay Freedman 207.7K Reputation points Volunteer Moderator
2011-01-16T19:03:42+00:00

When you insert a statusbar control (default name StatusBar1), it has one panel, which is StatusBar1.Panels(1). Then you can change the text on that panel like

   StatusBar1.Panels(1).Text = "some text"

You can also add more panels, and set a bunch of properties for each panel.

Jay Freedman

MS Word MVP  FAQ: http://word.mvps.org

Was this answer helpful?

0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-01-16T21:35:58+00:00

    Okay now I see panel has a style object that has several nice properties like current date and time . Great thanks again

    Was this answer helpful?

    0 comments
  2. Anonymous
    2011-01-16T21:30:29+00:00

    Thanks . It seems panels are added one after another horizontally . The immideate use I can see for this control other than usual status bar control messages is building a progress bar , although I probably prefer progressbar control. Any other usage for this control?

    Was this answer helpful?

    0 comments