Add Property to UserForm via class module - please help

Hi,

I have problem writing class module and connect it to my Userform (in attachment my macro)

My userform is called "FormyAnulacji" and i want to add to them one more property:

FormyAnulacji.Rows = it will be LastRowStatement.

Class Module:

Please Login or Register  to view this content.

For example my property Rows = 10.

So i want to set this property like this in module:

FormyAnulacji.Rows = 10

and next FormyAnulacji.show

and inside my userform i should have this property which i can set up once again in userform.

Or maybe I can do it directly in userform (not use module?)

So goal:
Write additional property to my userform in order to use it inside all buttons and listbox within userform.

Please help,
Best Regards,
Jacek Antek

Hi Guys,

I am Guru - I solved the problem which is simple.

First of all you have to declare additional property to your userform (inside userform - in the beginning):

Please Login or Register  to view this content.

So Wiersz_Gl it is ma additional property to userform.

In my userform it is simple (when combobox for example change - you can put it wherever you want)

Please Login or Register  to view this content.

So this will first go through Let property like this (you are set the variable for Wiersz_Gl userform property):

Let.jpg

And next you supposably want to get this property in commandbutton (or listbox, or textbox - wherever you want) in the same userform:

Please Login or Register  to view this content.

your code will get the variable from your defined property:

get.jpg

It is simple !

I hope that my struggle with this will be useful for somebody.

One thing is important here, one question - is this method quicker than reference to Function procedura? Getting class of the object? Maybe you know that.

Warm Regards,
Jacek Antek

Jacek

What are you going to do with this property?

Jacek

Can't you get that using the existing ListCount property of the controls?