I have a userform with a number of TextBoxes (named "TextBox1" through to "Textbox17") and a command button ("cmdInputData")

Each textbox has as its Change() event, code to verify that the user enters numerical data only. The UserForm's Activate() event ensures that cmdInputData is not enabled.

I want to use the AfterUpdate() event of TextBox17 to run code to cycle through each textbox, check if there is an entry and if each of the seventeen boxes contain data, to change cmdInputData to enabled.

I'm currently using a For ... Each loop but struggling with the syntax. Can anyone help me out, please?

Thanks