Help with Input Box.
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 |
Help with Input Box.
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 |
All times are GMT +1. The time now is 01:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com