+ Reply to Thread
Results 1 to 2 of 2

My code is running pretty slow with the loop that i have

  1. #1
    Forum Contributor
    Join Date
    01-18-2005
    Posts
    238

    My code is running pretty slow with the loop that i have

    The code below is how I am currently filling a listbox with options.

    I always show the first and last name of the record along with the lookup field (which can be any of the choices, and just changes the offset of the lookup column)


    But my code is running pretty slow to load the box. Is there another way to go about this with possibly an automatic filter????


    Please Login or Register  to view this content.

    thanks for any help


    Josh

  2. #2
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    Josh

    One way to speed up macros is not to select or activate sheets, rows, columns, ranges, cells etc


    Try this modification

    Note:- in your macro you have a declared variable strLookupField that gets loaded with the same value as strFirstName. You are doing nothing with the strLookupField so I have removed it
    Please Login or Register  to view this content.
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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