Results 1 to 5 of 5

For Each / Next

Threaded View

  1. #1
    Registered User
    Join Date
    03-03-2005
    Posts
    20

    For Each / Next

    I need some help using for each / next, as I am not very familiar with how to use it. I have a worksheet with many combo boxes. I want to ensure that all of these drop downs have an answer before being emailed back to me for review. I was thinking something along these lines...

    Dim Question As ComboBox
    Dim Question As String
    Dim WS As Worksheet

    For Each WS In Worksheets (do not know what i need here)
    If Question = "" Then
    Msg = MsgBox("All questions have not been completed. Please double-check the drop down boxes to ensure no questions were left unanswered.", vbOKOnly, "Missing Answers")
    End If
    Next Question

    Can anyone help me?

    Thank you,

    NicB.
    Last edited by NicB.; 05-22-2006 at 09:52 AM.

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