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

Answers


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?


Need Your Help

Calculating pi in pthreads

c multithreading pthreads

I am trying to calculate pi using the bpp method but my result keeps coming up at 0.The whole idea is for each thread to compute a part of it and the sum of each thread gets summed up using the join

sendto() fails, cuts telnet connection and blocks program

c udp telnet blocking errno

I've been stuck with this problem for days and I really cannot figure out where this comes from.