MSForms.CommandButton problem

[pmguerra]

Hi!

I've worked a solution for my problem but I would like to understand why this happens.

I have a form with 2 buttons and a frame. Inside the frame I have another button. I get a Type Error Message when I run the code and I don't understand why.

Here is my code

Please Login or Register  to view this content.

I've worked a solution using the following code (I saw this in another thread).

Please Login or Register  to view this content.

Can anybody enlighten me?

Thank you!

[Andy Pope]

The controls collection returns many different control types depending what is on the userform.

You defined the loops index object as being speficially a CommandButton, so when the first control that is not a command button is returned an error would be raised. The for each loop is not clever enough to return only commandbuttons.

[pmguerra]

It is a bit strange since it is declared as a commandbutton...

I'm assuming that the alternative code I've used is the correct one.

Thank you for your reply!

[Andy Pope]

Declaring it explicity as a commandbutton is the problem.

When it loops through ALL of the controls those that are not commandbuttons will cause the loop to fail.

The second way is how to do it. Loop with a Control index variable and test for control type to perfrom tasks on properties that may only apply to that control type.