Userform properties

[JohnSeito]

Hi,

I am trying to work with userforms in excel, I am not that familiar with userforms. I was looking at a sample example that I have and I see that when you click properties on the userforms, the left side there is a userform properties, and you can click on a down arrow and see selections of other properties (LabelText Label, LabelProgressBack Label, LabelProgress Label) that is for the same userform.

I was wondering how they create this and why so many properties?

Thanks,

[Leith Ross]

Hello JohnSeito,

Visual Basic for Applications is an event driven object based programming language. Each object has its own set properties and objects can even reference other objects to make use of their properties. Objects can have properties, methods, and events. Properties generally describe a characteristic of the object, like height, or width. Object methods are generally internal Sub or Function calls that perform a specific action on the object like copying or pasting. Events can be triggered by external events like clicking or typing. Sometimes events are triggered through code.

The properties you see listed are part of what is called a "property sheet". This is part of the object's Class module. This is the code that describes what properties, methods, and events the object has, uses, and responds to. It is a blue print from which other objects are created.

Sincerely,
Leith Ross

[JohnSeito]

Thanks....