Display the number of iteration in the input box of excel vba for every iteration
I have to display the input box with a message having the number of iteration in it. Please help.
Eg:I need the input box to display the message as "Please input Name: 1" for first iteration then "Please input Name: 2" for second iteration and so on depending on the number of iterations.
Appreciate an early reply.. Thanks, Learner_VBA
This can be done using the following:
For i = start to limit Input = InputBox("Please input name:" & i) 'Rest of code here ' ' ' next i
Just curious, but how many iterations are you looking at?