VBA listbox help

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Killer42
    Recognized Expert Expert
    • Oct 2006
    • 8429

    #16
    Originally posted by albertw
    hi
    just what i meant
    if the thing.listcount =0 then the procedure will be skipped
    Yes, as albertw points out, if the listcount is 0 the For statement will be set to loop from 0 to -1. In which case, we will never enter the loop.

    Comment

    • Blckbx
      New Member
      • Oct 2006
      • 21

      #17
      Originally posted by Killer42
      Yes, as albertw points out, if the listcount is 0 the For statement will be set to loop from 0 to -1. In which case, we will never enter the loop.
      my mistake i'd left in the userform1.show above the code, then closed it to run the code underneath and it'd reset the .listcount to 0. works now.

      cheers

      black box

      Comment

      Working...