Hello, I am using a form in excell 97 and I am trying to use a for loop (via a user form) to loop through a number of text boxes; altering the value of each text box.Private Sub Command1_Click() for i = 1 to 3me.textbox(i).value = inextEnd SubThe textboxes are named txtbox1, txtbox2 and txtbox3. I was trying to use i to alter the name. I get a message stating that an object is not declared.I have also looked to see if I could set the index property to 1, 2 and 3 respectively but can't find where to do this.Can anyone help?Many thanks
This is much more than an "Absolute Beginners" type question.If you don't get a response after a period you may be better closing this thread and re-posting in the Helproom.
give it about a week then post this same question on the Helproom.
This question does also appear in the Helproom.
This thread is now locked and can not be replied to.
Samsung Galaxy S9 review
Wacom Cintiq Pro 24 and 32 review – hands-on
When is the next Apple event?
Les meilleures séries Amazon Prime Video (2018)
© Copyright 2018 IDG UK. All Rights Reserved.