Error 91 when counting and adding commandButton

[selector]

Hello,
i have Userform1 with a few CommandButtons. When i run my VBA code, it return Error 91 - object variable or with block variable not set

What would i like to do:
1. I would like to count number of controls on Userform1
2. I would like to do something with CommandButton1 whitch is placed on Userform1 (change Caption, position ...)

Please tell me why the Error 91 occurs in this VBA code and how to repair it?

Please Login or Register  to view this content.

Thanks for reply

[LJMetzger]

Hi selector,

Try the following code tested using Excel 2003. However, to actually use the Command Button is a lot more complicated. To do that you probably need a 'Class Module'. See the following (excellent) example, which will probably make your head spin several times.
http://stackoverflow.com/questions/1...g-vba-on-excel

Lewis

Please Login or Register  to view this content.

[selector]

Thank you for your answer.
I find another way to resolve my problem. This code does not return error message and do exactly what i need:

Please Login or Register  to view this content.

[LJMetzger]

I apologize for misreading your original question. I thought you wanted to add a Control dynamically, not change it's properties.

The following may help you in the future.

Lewis

You can change CommandButton1 properties as follows:

Please Login or Register  to view this content.

Another way similar to yours is:

Please Login or Register  to view this content.

You may find the following routine useful:

Please Login or Register  to view this content.

And finally, if you want to see if a control exists:

Please Login or Register  to view this content.