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.
Galaxy Note 8 vs iPhone X
Awful clip art from 1994 is being tweeted every hour by a bot
iPhone X vs Samsung Galaxy Note 8
Les meilleurs navigateurs internet 2017
© Copyright 2017 IDG UK. All Rights Reserved.