I am trying to write a program using input box and a loop. I want the
program to ask the user for info for column c(blank cell), which is the
miles, then info for coln a, & B. The program will then take the given info
for col C then loop thru column A . Col C will then be populated with the
given miles until the state(col A) changes. Then another input box will pop
up prompting the user for the new state, miles, qty.

Below is a sample of my data
Col A(state) Col B(qty) Col C(Miles)
NY 2
NY 2
NY 2
TX 1
TX 1
CA 3

Do not use inputboxes for this. Use a form:
http://www.contextures.com/xlUserForm01.html

HTH. Best wishes Harald

"mju" wrote in message
...
I am trying to write a program using input box and a loop. I want the
program to ask the user for info for column c(blank cell), which is the
miles, then info for coln a, & B. The program will then take the given
info
for col C then loop thru column A . Col C will then be populated with the
given miles until the state(col A) changes. Then another input box will
pop
up prompting the user for the new state, miles, qty.

Below is a sample of my data
Col A(state) Col B(qty) Col C(Miles)
NY 2
NY 2
NY 2
TX 1
TX 1
CA 3