chuyensinh
03-25-2012, 11:17 AM
Hello,
Someone could help me make the following program, please:
Create a macro with one or more loops of type "DO WHILE" which ask user to enter two values: the first value between 1 and 4, the 2nd value between 1 and 3
If for each value, the value entered does not meet the criterion, the program will display the message: "the value entered is not correct" and ask again that value until compliance constraints.
This macro will enter the numbers from 1 to 100 starting from the cell "A1" of sheet 1 by shifting each value of the number of lines corresponding to the first required value and the number of columns corresponding to the requested value 2nd.
Someone could help me make the following program, please:
Create a macro with one or more loops of type "DO WHILE" which ask user to enter two values: the first value between 1 and 4, the 2nd value between 1 and 3
If for each value, the value entered does not meet the criterion, the program will display the message: "the value entered is not correct" and ask again that value until compliance constraints.
This macro will enter the numbers from 1 to 100 starting from the cell "A1" of sheet 1 by shifting each value of the number of lines corresponding to the first required value and the number of columns corresponding to the requested value 2nd.