+ Reply to Thread
Results 1 to 4 of 4

Loops in VBA

  1. #1
    Registered User
    Join Date
    03-17-2009
    Location
    Detroit,USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Loops in VBA

    This code below does the following:

    The user enters strings in a input box. A message box is then returned giving the user information about the string entered. When the user clicks the ok button on this message box, the whole process repeats itself until the user clicks cancel on the input box. I have two problems.

    My first problem involves the if statement. If the condition of the if statement is true a message box appears telling the user that the string entered was too short (less than 10 characters). After the user clicks the Ok button in the message box, i want the input box in the beginning of the code to appear again giving the user a chance to enter the correct number of characters.

    My second problem is that I am trying to figure out how I can return a message to the user when they are done entering strings (this would be when the user clicks cancel on the input box)

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Loops in VBA

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-17-2009
    Location
    Detroit,USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Loops in VBA

    What does this part of the code do?

    Please Login or Register  to view this content.

  4. #4
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Loops in VBA

    It checks if anything was entered in the inputbox.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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