Search:

Type: Posts; User: TrainingExcellence; Keyword(s):

Search: Search took 0.00 seconds.

  1. Listbox enlarges as entries are made until command buttons are covered.

    I have a form with a listbox. The form is set up so that I type entries into a series of text- and comboboxes, and then press a command button to add the values into the listbox (see picture:...
  2. SUMIFS Function Is Performing Inconsistently

    This problem has been driving me nuts, because it should be simple, but it's not working. I have the following formula in a table called tblCurrentHoldings on the sheet CurrentHoldings (see...
  3. Re: Loop macro works on individual sheets, but locks up when looping through multiple sheets.

    It varies depending upon the workbook, but I'd say up to a dozen or so worksheets.
  4. Re: Loop macro works on individual sheets, but locks up when looping through multiple sheets.

    Okay, so here is what I notice. When I put a break at the Next statement (the one towards the end of the script) and press f5 to move through each interval, the macro works perfectly. But when I...
  5. Re: Loop macro works on individual sheets, but locks up when looping through multiple sheets.

    Ahh, StephenCrump, that totally makes sense. I'm pretty sure it is just in a perpetual loop.

    Thanks footoo, but for some reason the macro isn't stopping when it comes to the Consolidation...
  6. Loop macro works on individual sheets, but locks up when looping through multiple sheets.

    Greetings!

    I've been learning VBA and have found this forum to be extremely helpful! This is my first post. I'm having trouble with a macro I'm creating at work. I have a number of xls-refreshable...
Results 1 to 6 of 6