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

How to use the removeClass() callback function?

jquery regex removeclass

since jQuery 1.4 removeClass(); now takes a function as argument.

Dumping contents of Array Obj-c to consoler

iphone printing nsmutablearray

I looked for how to dump and array to the console I have mostly found:

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.