Immediate Window in VBA IDE скачать в хорошем качестве

Immediate Window in VBA IDE

Weblink https://learnyouandme.com/get-most-fr... In this video, you will see how to use Immediate Window in VBA IDE. In VBA Immediate window is very helpful in testing a code line quickly to see its output or action. If you want to get answers or some output from a code line then precede "?" (question mark) before the code line then press Enter to get output. If the code line performs some task or action just write that line and press Enter to perform an action. ====================================== This will video will show you how to use the immediate window in VBA IDE. IMMEDIATE WINDOW ( CTRL +G shortcut Key) This is special type of window in VBA which can be used for immediate testing of a code line. In general VBA statements can be divided into 2 types. 1 - Statements or VBA functions or UDF which give some value as output and these statements must be prefixed with ? mark in Immediate Window. Eg. ?Date, ?Now, ?5+9 , ?5=4, ?len("test"), ?Range("A1").value, ?Activecell.value, ?Activesheet.name, ?Thisworkbook.name , ?Thisworkbook.sheets.count etc. Place cursor at end of these statements and press ENTER to get output. 2 - Statements or VBA methods or sub which perform some action on excel object. Do not put ? mark as prefix for such type of statements. Eg. Sheets(1).Activate, Range("A1").Value="Knowledge", Range("A1").ClearContents, Range("A1:B5").Select etc. Place cursor at end of these statements and press ENTER to perform action. Debut.Print is used to output value in Immediate Window from Sub or Function. '====Codes used for this video Option Explicit Sub testMsg() MsgBox "I am learning use of IMMEDIATE WINDOW." End Sub Function TotalSheetCount() TotalSheetCount = ThisWorkbook.Sheets.Count End Function Sub PrintSheetNames() ''prints sheets name in IMMEDIATE WINDOW Dim shet As Worksheet For Each shet In ThisWorkbook.Worksheets Debug.Print shet.Name Next End Sub '=============== 🌐 Websites 🌐 🌎https://learnyouandme.com 🌎https://www.juggle.biz 🎫 Make your Digital Visiting Card https://mydvc.info/ 🔵Facebook   / learnyouandme   🔴Quora link https://www.quora.com/profile/Abhishe... '=============== 📌📌You can watch and learn from the below videos also.📌📌 ✅ Vlookup to return multiple values in one cell In Excel ( 3 Methods) | TextJoin If    • Vlookup to return multiple values in one c...   ✅ Abbreviation Function In Excel (VBA UDF for Short form|Abbreviation)    • Abbreviation Function In Excel (VBA UDF fo...   ✅ Vlookup to return duplicate matched values or return all matched lookup values - method 1    • Vlookup to return duplicate matched values...   ✅ Fastest Vlookup formula (exact match type)    • Make Vlookup formula fast in Excel | Faste...   ✅ Fastest Vlookup formula (exact match type)    • Make Vlookup formula fast in Excel | Faste...   ✅ Vlookup to return duplicate matched values or return all matched lookup values - method 2    • Vlookup to return duplicate values or vloo...   ✅ Choose formula in excel with an example    • How to use Choose function in Excel | Choo...   ✅ Change line or paragraph or simulate line break using concatenate and char function.    • Change line or Paragraph or Simulate Line ...   ✅ How to reduce large excel file size in few seconds using excel binary format?    • How to reduce large excel file size in few...   #learnyouandme #learn#you#and#me #learnyouandme#vba