Results 1 to 42 of 42

For Each..Next Loop Issues

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-15-2012
    Location
    California, USA
    MS-Off Ver
    Excel 2016 / Office 365
    Posts
    115

    For Each..Next Loop Issues

    Attached is a file that I am having a little trouble with. The Master BOM Sheet has a button to process 20 different Group BOM Sheets based on the Value of the Group Unit Qty. We have been using this file for some time now and I was recently asked to modify the process.

    Currently the Process Group BOM Button is linked to UserForm1 which has a ListBox with Group 1 - Group 20. The user double clicks the Group that they would like to process and the form closes. If the user is processing all 20 groups, it gets a little tedious to press the button 20 times and double click each individual Group. I have created UserForm3 with CheckBoxes and an OK button in hopes that if the user checks 3 boxes that the For Each Loop will process all 3 sheets one after another. Here is where I need some help.

    If one box is checked, it processes the Group BOM just as UserForm1 Does, but if multiple boxes are checked, it will not process any of them. I also noticed that if I open the UserForm3 and process one Group, then open the form again and cancel out of the form to close it, the data that was last processed gets erased from the Group BOM Sheet.

    Right now the sheet code is set to open UserForm3 in the Sub FillLstBox procedure (I left the terminology the same until I get the process complete) when the button is pressed. To see how the process works with the ListBox doubleclick event, change the Procedure to UserForm1.

    I had to remove a lot of sheets and additional VBA from this tool to get it on here. If someone wants to see the complete tool to get a better understanding of what is going on, I can send it in Email just let me know.

    Really need some help here.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Loop issues ............. I give up :-(
    By hotdog6660 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-09-2013, 09:01 AM
  2. loop issues
    By short_n_curly in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-19-2010, 02:44 PM
  3. Issues with Do While Loop
    By great.bean in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-05-2009, 11:35 AM
  4. Loop Until Issues
    By jlejehan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-20-2006, 11:45 AM
  5. Loop Issues
    By bigfatdummy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-23-2006, 08:15 PM

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