Loop through controls in UserForm

[JezLisle]

I have taken this code from Access and trying to use it in Excel to lock all the TextBox, ComboBox & CheckBox on the form.

Please Login or Register  to view this content.

In Access this works fine but trying it Excel it tells me variable not defined and highlights the acTextBox as the problem.

How can I get around this as otherwise I have to code every single control and this would make my code enormous?

[antoka05]

Try with this code:

Please Login or Register  to view this content.

Regards,
Antonio

[royUK]

I always dim controls as MSForms controls, I have had problems with just using Control. Try this

Please Login or Register  to view this content.