loop listboxes

  1. R

    Looping thru Listbox

    Hi, Throughout my process, I populate ListBox4 with a variable number of rows (8 columns). When the user clicks the commandbutton, I wish to loop through ListBox4 and write each row (with the 8 columns) to sheet1. Example (ListBox4): 9999| Anytown| CA| 12345| Monday| 4/30/2012| 8:00AM|...
  2. 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