Closed Thread
Results 1 to 6 of 6

Performance Optimierung

  1. #1
    Registered User
    Join Date
    09-23-2021
    Location
    Bavaria, Germany
    MS-Off Ver
    365
    Posts
    5

    Performance Optimierung

    Hey zusammen,

    ich oute mich als Fußball-Nerd. Ich habe mir für mein Managerspiel eine Excel erstellt und jetzt bin ich nicht 100% zufrieden mit der Performance. Ich filtere eine ListBox und wenn ich relativ schnell tippe, dann hängt das ganze etwas. Habt ihr Ideen, wie ich mein Progrämmchen schneller kriegen könnte?


    Please Login or Register  to view this content.
    Vielen Dank im Voraus.

    Beste Grüße
    StativBus

  2. #2
    Registered User
    Join Date
    09-23-2021
    Location
    Bavaria, Germany
    MS-Off Ver
    365
    Posts
    5

    Re: Performance Optimierung

    Mir fällt gerade auf/ein, dass der Grund für die schlechte Performance auch darin liegen kann, dass immer auch der erste Eintrag ausgewählt wird. Zu diesem werden dann die Marktwerte der letzten sieben Tage und die Veränderungen zwischen diesen ausgerechnet. Ist vielleicht eher das der Grund?
    LG

  3. #3
    Registered User
    Join Date
    06-20-2021
    Location
    UK
    MS-Off Ver
    2016
    Posts
    72

    Re: Performance Optimierung

    There is regional section in this forum I believe.

  4. #4
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    4,119

    Re: Performance Optimierung

    At the top left there is a tab "Forum" (beside "What's New").
    Click on that and you'll see "Non English Forum" or something similar.
    Put your question in that part of the forum if you want to converse in German.
    Or you can translate your own with Google, have someone else translate it for you or hope people here will take the extra time to translate it.
    And who knows, you might run into someone that is bi-lingual enough to answer your question.
    Good Luck though.

    I suffer from:
    I am byelingual.
    I speak two languages but start losing vocabulary in both of them.

  5. #5
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,879

    Re: Performance Optimierung

    Verwende Sie AfterUpdate anstelle von Change.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11 64-bit)
    Posts
    53,193

    Re: Performance Optimierung

    As I believe this is the same query (die gleiche Frage), I am closing this thread in favour of the one just opened in the English section (which will get better footfall).

    I suggest you copy the code across to the new thread: https://www.excelforum.com/excel-pro...ooty-team.html

    Thread closed.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel Performance: Tips for optimizing performance obstructions
    By dangelor in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-06-2019, 06:33 PM
  2. [SOLVED] performance %
    By Chickenkicker99 in forum Excel General
    Replies: 5
    Last Post: 10-14-2017, 04:56 PM
  3. current moth MTD performance with last year same month same days performance
    By satyanarayana in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-03-2015, 03:36 AM
  4. Performance
    By speedup in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-19-2015, 11:55 AM
  5. Replies: 4
    Last Post: 11-23-2014, 05:54 PM
  6. [SOLVED] Sum last year's year-to-date performance as we enter this year's performance...
    By LSR1011 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-02-2013, 11:31 AM
  7. [SOLVED] Performance IF(IF or IF(AND
    By Paul Dennis in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-20-2006, 12:30 PM

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