loop controls

  1. P

    VBA For.. Next.. Loop Equivalent of "Continue For"

    Group, I have a very simple For/Next Loop that simply says: For rowNo = 2 To 2000 Go do some stuff Next rowNo However I need to insert a "Goto the next iteration of this loop" in a IF statement. However I'm struggling to find the correct syntax to make this happen. Can you help? I need...
  2. E

    Setting up a loop to compare two columns

    Hello, I realize this is a silly question but I'm very new at this so please be patient with me. Let's say I have something like this (that I've parsed from a XML file, where the AnimalType returned 3 values in this order): I'm trying to make it like this: So the thing is, I want to...
  3. D

    Update Chart Filters Based on Range In Spreadsheet

    Objective: to use a list of items in a specified range to update a pivot chart I know the code below points to what I am needing, but I think I need to create a variable to step through a range so that I can add them to the code below: (something like Range = Sheets("Main").Range("A1:A10") for...
    • drmingle
    • Thread
    • excel 2007 loop controls pivotitems range and macro vba
    • Replies: 0
    • Forum: Excel Questions
  4. J

    Looping through Controls in Multipage only working for 1 page

    Hi everyone hope you can help with this one, I'm starting to tidy up my code and make is shorter instead of repeating things multiple times, so i have been learning about For loops. I have a userform with several multipages, each page has 5 questions, which are pulled through from an excel...
    • jparfitt87
    • Thread
    • funciton loop controls multipage user form vba & excel 2010
    • Replies: 1
    • Forum: Excel Questions
  5. B

    Newsletter Code / Customize loop

    Hello, I found this code on a blogspot belonging to Milos Holovsky. Macros in Excel | What is an Excel Macro?: VBA to send a Outlook Draft Email to a list of emails in Excel I am a complete beginner and I need your help. This macro will loop through a list of emails addresses and send a...
  6. P

    Loop through textboxes to find empty then add text

    I have a combobox with a list of Extra work Descriptions called "ExtrasComboBox" that allows the user to choose a list of Extra work which is on a Userform called "ExtrasUserForm". I have created a command button called "SaveCommandButton" that on "click" triggers the event! I also have another...
  7. AOB

    Cycle through all listboxes in a form (XL2007)

    Hi everybody, Does anybody know how to loop through all listboxes on a user form? I'm trying to cycle through a set of list boxes (10 for now but that number may grow) and populate them with distinct values from corresponding fields in a database. I've set up the listboxes on the form such...
    • AOB
    • Thread
    • loop controls loop listboxes userform
    • Replies: 3
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top