Results 1 to 3 of 3

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

Threaded View

  1. #1
    Registered User
    Join Date
    03-28-2010
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    60

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

    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.
    Last edited by learning_vba; 03-28-2010 at 09:29 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1