Using Do and For Loops to get an integer value from a user

**learning_vba** · 03-28-2010, 07:33 PM

Hello,

This is my first post and I appreciate any tips that can be offered to me on the following problem I am trying to solve. I am learning VBA in a college course and have a homework problem I am having difficulty figuring out (I am brand new to VBA).

Here is the setup:

Write a sub that asks a user via inputbox for an integer value between 1 and 5. This should be embedded within a Do loop so that the user keeps getting asked to input a number until they input an integer between 1 and 5. Use a For Loop for error checking.

This is not the exact problem I am tasked with completing, but it is similar and will help me to learn the particular coding techniques I need to know to complete the problem.

Thank you again for any help.

Regards.

**Leith Ross** · 03-28-2010, 09:24 PM

Hello learning_vba,

Welcome to the Forum!

As a general rule, we do not provide answers to homework questions. The reason is obvious. In this case I will make an exception because your assignment doesn't have anything to do with looping structures but with validation and conditional transfer of execution.

This macro will transfer control back to the line label "GetInput" based a series of validation tests. If any validation step fails, execution returns back to this line to ask the user to input a value again. An error dialog will be displayed alerting the user to the mistake.

Please Login or Register  to view this content.

**learning_vba** · 03-28-2010, 09:28 PM

Thank you very much for your help. I understand not answering the actual questions, but this one is not the exact question I have to answer. I appreciate the help and this will certainly help me to further understand what I am doing.

Regards.