Excel VBA Introduction Part 40 - Disabling Screen Updates

Поділитися
Вставка
  • Опубліковано 2 лют 2025

КОМЕНТАРІ • 13

  • @Gk2810_
    @Gk2810_ 9 років тому

    i know screen updating = false since a year thanks to you ... but i love "time taken" hack . thank you sir ... very informative ....

  • @divyal5852
    @divyal5852 8 років тому

    This is one of my favourites! Thank you very much Andrew!

  • @imranbhatti8580
    @imranbhatti8580 8 років тому

    I used to think about this piece of code in excel vba "Screen updating=false or true ,,what was it....but after watching this video my concept is cleared ...Thanks wise owl

  • @peterhontaru5537
    @peterhontaru5537 5 років тому

    Fantastic video as always - thank you!

  • @kumkumsaini5590
    @kumkumsaini5590 11 місяців тому

    Fantastic video ever, There is no second module available in file with data to download please share it.

  • @janezklun
    @janezklun 9 років тому +2

    great video, thank you for sharing

  • @ElonMuchen3737
    @ElonMuchen3737 8 років тому

    Andrew, thanks for sharing your knowledge. You are a great teacher!
    I have a question. Is there someway to put a kind of timer to start a sequence of codes after a specific time? Sorry for my English.

  • @AubreyGreenJr
    @AubreyGreenJr 9 років тому

    If you add a screenupdating = true at the end then you would not have to end the macro to see the result. Or did you have to leave it to see the time? Ohterwise, nice tutorial...

  • @DennisYeadon
    @DennisYeadon 7 років тому

    Andrew, you have created an excellent series of videos. Thank you so much. I have just one question at this time. Where may I find the movies workbook? Again, thank you for all your help as I learn VBA.

  • @danielmwippel
    @danielmwippel 3 роки тому

    If I don't turn screen update on again at the end of the sub routine will it be enabled automatically?

    • @WiseOwlTutorials
      @WiseOwlTutorials  3 роки тому +1

      Hi Daniel, Microsoft's recommendation is to switch it back on docs.microsoft.com/en-us/office/vba/api/excel.application.screenupdating#remarks

  • @Ronnet
    @Ronnet 8 років тому

    Great video! But the link in the description doesnt work

    • @Ronnet
      @Ronnet 8 років тому

      ***** Thank you for the quick response and the file! And of course a much bigger thanks for all these very well made videos. They're the best videos I've found on UA-cam about VBA by a mile!