acmelitesoft.bitballoon.com

var q compaqpresario1500driversforwindowsxp 8. 1. Discussion Thread Date Compaq Compaq CQ57 Windows 10 x64 SCSI Dec 20, 2016 Compaq sr5450f Windows Vista SCSI May 5, 2016 Compaq Presario 2500 Windows XP. Compaq CD DVD Drivers Download for Windows 1. XP, Vista. It is easy to find the right driver for your installed device. We have the most supported Compaq CD DVD Drivers available for Free Download. And for the most popular Compaq products and devices. Use our custom search to find popular Compaq CD DVD models. You can also search our whole driver archive to find the exact driver that fits your needs. Browse the list below of the most popular Compaq CD DVD devices to find yours. Elenco di driver e software per Hp laserjet p2015, suddivisi per sistemi operativi Windows Mac e Linux. DriverTuner was created to save your time resolving driver problems by providing you with a single, automatic tool. If your laptop does not start at all or it starts but will not boot properly, its possible that you. Or go for automatic driver updates and get the correct Windows driver with just one click. The best way to fix your PC to run at peak performance is to update your drivers. Below is a list of our most popular Compaq CD DVD support software and device drivers. First select the Model Name or Number of your device. Next click the Download button. If you do not find the right match, type the model in the search box below to Search our Compaq Device Driver Support Database. You may see different versions. Choose the best match for your PC. Need more help Discuss driver problems and ask for help from our community on our Free Driver Help Forum. Or you can request a driver and we will find it for you. We employ a team from around the world. They add hundreds of new drivers to our site every day.

var q dynamictradersoftwareWall Streets Robots Still Have a Lot to Learn About Being a Human Trader. Back in the 1. 99. Paul Tudor Jones assigned a team of coders to a project dubbed Paul in a Box. The effort sought to break down the DNA of the hedge fund managers trading how he sizes up markets and generates ideas to train a computer to do the same. The code created then was upgraded many times and is still used at his firm, Tudor Investment Corp. But it never took over. Paul Tudor Jones. Photographer Michael NagleBloomberg. Again and again, programmers had to feed in new types of data to mimic the changing price signals that Jones, famous for predicting the Black Monday market crash 3. Even then, the machine couldnt capture intangibles like his gut instincts and conviction, as well as the markets uncertainties. Ultimately, Jones remains the final decision maker for trades not the box. The limits of that model show why many jobs at the high end of finance are probably safe from automation a little longer. While machine learning algorithms and other technologies are indeed encroaching on work performed by money managers, traders and analysts, many firms are still working out the kinks. Coders will be busy for years. See the graphic Robots of Wall Street are coming for these trading jobs. One not so well kept secret of Wall Street is that many companies rely on aging computers. Firms that werent founded as algorithmic powerhouses often use a hodgepodge of trading platforms, Excel spreadsheets and data stored across servers that arent in sync. Replacing staff with machines means automating roles that are idiosyncratic. And then there are executives, now in the prime of their careers, reluctant to usher in an era that no longer needs them. In a sense, automation is ready to tackle Wall Street but not the other way around. Even after coders overcome those technical issues, their software will need frequent fine tuning. Michael Dubno, the chief architect of Goldman Sachs Group Inc. s risk management system known as Sec. DB, said thats one reason why salespeople and traders, at least for now, arent obsolete. They have mental models of the world that are more complex perhaps than most of the computer systems, he said. In the short term, artificial intelligence isnt going to move as fast as people expect. It will go through a number of fits and starts, where it will look like its going to solve everything and then solve very little of it and then its going to reset. The finance industry is hiring coders to automate tasks. Algorithms are being taught to parse troves of data and identify patterns and relationships. The idea is to let machines calculate, for example, the odds that Apple Inc. More than half of the 1. Goldman Sachss securities division advertised online earlier this year were for tech workers. The bank told some recruits, for example, that they may build a chatbot that uses natural language processing which lets machines to comprehend human speech and Bayesian inference a statistical technique to suggest trades, according to listings on its website. Other firms have employees tinkering too. At billionaire Steven Cohens family office, a secretive project has been experimenting with automating his best money managers. But while money managers including Jones try to accelerate adoption of new tech, others are already far along. Renaissance Technologies, the quant fund founded by former military code breaker Jim Simons, has been using machine learning techniques for years, building a track record envied by the industry. Competitors relying on old fashioned gut trading, meanwhile, have been suffering from lackluster returns and investor withdrawals. The average age of software in finance is about 3. CB Insights. And data, the bedrock upon which AI is built, are often fragmented or inaccurate. The No. Dubno, a former technology chief at Goldman Sachs and in Bank of America Corp. s global markets business. The standard plight for many firms is that theyre stuck in a world where their data is stored all over the place. Mike Dubno, former chief technology officer at Goldman Sachs, speaks with Bloombergs Hugh Son on automation. Source Bloomberg. Machine learning is valuable for tasks such as fraud detection and credit risk analysis, but adapting it to trade in rapidly evolving markets is difficult, according to Alexey Loganchuk, who places data scientists at hedge funds. By the time you have enough data to build a complex model, the dynamics you are trying to capture have often changed, he said. Its hard to teach AI to take over sales, trading and investing roles, according to the Nomura Research Institute, which this year studied what it would take to apply natural language processing to portfolio management. The workflow is irregular and ad hoc, said Yasuki Okai, president of NRI Holdings America. His company is partnering with tech firms to help solve problems. Forecasting other market players reactions to markets is an added complication. Automating traders who handle illiquid securities, for example in credit markets, can be especially challenging because so much of their job hinges on judgment, the idiosyncrasies of each trade and human interaction. Traders use data that arent standardized or work with clients to create bespoke contracts, such as for commercial mortgage backed securities. Tudors Tinkering. Billionaire Jones, 6. One effort around 2. Synergy Project brought his top money managers and groups of coders together over lunch to dissect how managers react to things like economic data and central bank announcements, according to the people with knowledge of the project, who asked not to be identified discussing internal initiatives. Patrick Clifford, a spokesman for Tudor, declined to comment. Graphic Robots Are Coming for Wall Street Jobs. To develop cutting edge technologies, firms such as JPMorgan Chase Co. T. Rowe Price Group Inc. But even when Wall Street innovates, implementation may not be the top priority, according to Adi Prakash, chief innovation officer at consulting firm Yerra Solutions. Firms are under constant pressure to reward their investors and keep up with regulations. Inertia is the problem, said Prakash, who held various technology roles at Och Ziff Capital Management Group and JPMorgan. Its going to be a push to say that front office processes are going to be automated within the next one to three years. Not to mention the challenge of installing new systems on fast paced trading floors. People are hugely time constrained, said Craig Butterworth, global head of Nomura Holdings Inc. s client ecosystem, where hes leading technology initiatives across the trading business. There is definitely an If it aint broke, dont fix it type of mindset. And sometimes, there isnt even space available on desktops for cutting edge software. Dragging Feet. Another obstacle senior management. Executives may try to preserve the status quo because they have too much at stake their income and status, former bank and hedge fund employees say. Bosses may be reluctant to displace large swaths of their staffs, reducing their authority, or to embrace technology that they themselves dont understand. Top management rarely want change, they want to keep intact a system that has worked for them for decades, said Mansi Singhal, a former trader at Brevan Howard Asset Management and Bank of America. Charts, forecasts and trading ideas from trader TradingJazz. Get unique market insights from the largest community of active traders and investors. Picking The Right Algorithmic Trading Software. While using algorithmic trading, traders trust their hard earned money to the trading software they use. The right piece of computer software is very important to ensure effective and accurate execution of the trade orders. Faulty software, or one without the required features, may lead to huge losses. This article looks at key things to consider for picking the right software for algorithmic trading. For more, see Basics of Algorithmic Trading Concepts and Examples. Algorithmic trading software relies on a deep understanding of technical analysis. After all, technical indicators are often used as inputs for these trading systems. Investopedias Technical Analysis Course provides an in depth overview into how to identify technical patterns, trends, signals, and indicators that drive price behavior. With over five hours of on demand video, exercises, and interactive content, youll learn all major forms of technical analysis and access case studies showing how theyre used. A Quick Primer to Algorithmic Trading. An algorithm is defined as a specific set of step by step instructions to complete a particular task. Be it the simple yet addictive computer game like Pac Man or a spreadsheet that offers huge number of functions, each program follows a specific set of instructions based on an underlying algorithm. Algorithmic trading is the process of using a computer program that follows a defined set of instructions for placing a trade order. The aim of the algorithmic trading program is to dynamically identify profitable opportunities and place the trades in order to generate profits at a speed and frequency that is impossible to match by a human trader.  Given the advantages of higher accuracy and lightning fast execution speed, trading activities based on computer algorithms have gained tremendous popularity. For more, see The Pros And Cons Of Automated Trading Systems. Who Uses Algorithmic Trading Software Algorithmic trading is dominated by large trading firms, such as hedge funds, investment banks, and proprietary trading firms. Given the abundant resource availability due to their large size, such firms usually build their own proprietary trading software, including large trading systems with dedicated data centers and support staff. At an individual level, experienced proprietary traders and quants use algorithmic trading. Proprietary traders, who are less tech savvy, may purchase readymade trading software for their algorithmic trading needs. The software is either offered by their brokers or purchased from third party providers. Quants have a good knowledge of both trading and computer programming, and they develop trading software on their own. For more, see Quants What They Do and How Theyve Evolved. Algorithmic Trading Software Build Or Buy There are two ways to access algorithmic trading software build or buy. Purchasing ready made software offers quick and timely access, while building your own allows full flexibility to customize to your needs.  The automated trading software is often costly to purchase and it may be full of loopholes, which, if ignored, may lead you to losses. The high costs may take away the realistic profit potential from your algorithmic trading venture. On the other hand, building algorithmic trading software on your own takes time, effort and a deep knowledge, and it still may not be foolproof. The risk involved in automatic trading is very high, which can lead to large losses.  Regardless if one decides to buy or build, it becomes important to be familiar with the basic features needed. The Key Features Of Algorithmic Trading Software. Availability of Market and Company Data All trading algorithms are designed to act on real time market data and price quotes. A few programs are also customized to account for company fundamentals data like EPS and PE ratios. Any algorithmic trading software should have real time market data feed, as well as a company data feed. It should be available as a build in into the system or should have a provision to easily integrate from alternate sources. Connectivity to Various Markets Traders looking to work across multiple markets should note that each exchange might provide its data feed in a different format, like TCPIP, Multicast or a FIX. Your software should be able to accept feeds of different formats. Another option is to go with third party data vendors like Bloomberg and Reuters, which aggregate market data from different exchanges and provide it in a uniform format to end clients. The algorithmic trading software should be able to process these aggregated feeds as needed. Latency The smallest word of this list is the most important factor for algo trading. Latency is the time delay introduced in the movement of data points from one application to the other. Consider the following sequence of events. It takes 0. 2 seconds for a price quote to come from the exchange to your software vendors data center DC, 0. Total time elapsed 0. Total 1. 4 seconds. In todays dynamic trading world, the original price quote would have changed multiple times within this 1. This delay could make or break your algorithmic trading venture. One needs to keep this latency to the lowest possible level to ensure that you gets the most up to date and accurate information without any time gap. Latency has been reduced to microseconds, and every attempt should be made to keep it as low as possible in the trading system.  A few measures include having direct connectivity to the exchange to get data faster by eliminating the vendor in between by improving your trading algorithm so that it takes less than 0. Configurability and Customization Most algorithmic trading software offers standard built in trade algorithms, such as those based on a crossover of the 5. MA with the 2. 00 day MA. A trader may like to experiment by switching to the 2. Live Nifty HeatMap helps you to understand sectoral performance in the market. Nifty HeatMap gives instant graphical report of buzzing stocks and losers based on. MA with the 1. 00 day MA. Unless the software offers such customization of parameters, the trader may be constrained by the built ins fixed functionality. Whether buying or building, the trading software should have a high degree of customization and configurability. Functionality to Write Custom Programs Matlab, Python, C, JAVA, and Perl are the common programming languages used to write trading software. Most trading software sold by the third party vendors offers the ability to write your own custom programs within it. This allows a trader to experiment and try any trading concept she develops. Software that offers coding in the programming language of your choice is obviously preferred. For more, see Trading Systems Coding Introduction. Backtesting Feature on Historical Data Backtesting simulation involves testing a trading strategy on historical data. It assesses the strategys practicality and profitability on past data, certifying it for success or failure or any needed changes.  This mandatory feature also needs to be accompanied by an availability of historical data, on which the backtesting can be performed. Integration with Trading Interface Algorithmic trading software places trades automatically based on the occurrence of a desired criteria. The software should have the necessary connectivity to the brokers network for placing the trade or a direct connectivity to the exchange to send the trade orders.

var q rolandjv880patchesImportant Announcement The current format of the MIDI Forum is outdated, so its time to start a new, better one. Spammers are giving me a lot of trouble, I spend. The Roland JV1080 was one of the hottest and most popular digital synthesizers ever to come from Roland. Incredible sound quality capable of emulating any instrument. As in title my Jv2080 showed today message User Memory damaged. you had simillar problems Im afraid my beloved Roland is now just a fancy paperweight. Read. Roland JV 2. 08. Vintage Synth Explorer. Polyphony 6. 4 voices. Oscillators 8. MB of sample ROM and acoustic simulation. Expandable with SR JV8. LFO 2 LFOs sine, saw, square, triangle, trapezoid, sample hold, random and chaos w key or external sync. Can modulate the pitch, filter, pan, or level. Filter TVF lowpass, bandpass, highpass, peak with cutoff, resonance, key follow and velocity sensitivity. VCA TVA ADSR tone level, pan, key followMemory 1. Keyboard None. Control MIDI 1. Date Produced 1.

var q vimopenallfoldsinfileBest Open Source Web Browsers I Discovered for Linux in 2. Best Open Source Linux Web Browsers. Web Browser is a software which provides an interface to surf the web. With introduction in around 1. Earlier there used to be mostly text based sites with few having images and graphical content, hence only text based browsers sufficed with some of early browsers being Lynx, Netscape and Opera. Lets Drop The RUMORBOMB Fujifilm is forging a MEDIUM FORMAT CAMERA Source Right in Past WITH POLL. May 21, 2015 Rumors 292 Comments. User manual and reference guide version 5. 32. 1. CodeMirror is a codeeditor component that can be embedded in Web pages. The core library provides only the editor. History of Scintilla and SciTE Contributors Thanks to all the people that have contributed patches, bug reports and suggestions. Source code and. But, with advancement of technology to support of audio, video, images and even flash content, browsers also need to be that advanced to support such content. This has pushed the advancement of browsers to what we see today. A modern browser requires support of many softwares which include web browser engine like Geeko, Trident, Web. Kit, KHTML etc, Rendering engine to render the web site content and display in proper format. Linux being open source community gives freedom to developers across the globe to experiment with features they expect from an ideal browser. Some Open Source Browsers in Linux. Below are listed some Open Source web browsers which are just perfect to be listed here. Web Browser is a software which provides an interface to surf the web. In the article, we will list top best open source web browsers for Linux based on their. Arguments Description num Open editor with cursor on line num. If num is not specified, the cursor will be on the last line of the file. pat. The 15 most useful plugins for VIM. This post is a bit dated but kept intact to reflect the best plugins at the time. Vim the Six Billion Dollar editor. Better, Stronger, Faster. Learn vim and it will be your last text editor. There isnt any better text editor that I know of. I have spent the last few years tweaking and refining my VIM configuration. This is the ultimate VIM configuration. vimrc file. It is well organized and documented. Usually the features which distinguish a normal to a good browser are Ability to support all types of data including audio, video, flash and HTML and HTML5, fast performance, memory friendly to adjust to old and new systems completely, ability to support maximum architectures like Intel, AMD and operating systems like Windows, Mac, Unix like, BSD to name a few. Google Chrome. Accounted as the most popular web browser in smartphones and PCs with more than half usage share of web browsers, Google Chrome is a freeware developed by Google. This page seeks permission for personalized ads, personalization across all devices, access to your location, tracking to see where Twitter content is seen across web. In Lifehackers new video series, Day 1, were tackling exactly what its like to be a newbie in a variety of possiblyintimidating situations, starting off. It forked from Chromium whose code is modified with certain add ons to structure it. It uses Web. Kit layout engine till version 2. Blink thereafter. Written mostly in C, it is available for many Operating Systems including Android, i. OS, OS X, Windows and Linux. Features provided by Chrome include bookmarking and synchronization, enhanced security, malware blocking, and addition of external plugins like Add. Block etc available in Google Web Store which is provided as a default extension in Chrome. Also, it supports user tracking feature which can be enabled if required. It is fast because of inbuilt mechanism it uses, also is very stable with tabbed browsing, speed dials and incognito private browsing mode, provides custom themes which can be installed as an extension from web store. It is widely accepted as one of default browser which can be found in almost all systems, with mostly positive reviews. Google Chrome Browser. Firefox. One of the popular Web Browsers, Firefox is also Open Source and available for major operating systems including OS X, Linux, Solaris, Linux, Windows, Android etc. It is written majorly in C, Javascript, C, CSS, XUL, XBL and released under MPL2. License. Since its introduction, it has been praised for its speed and security add ons and even is often termed as spiritual successor of Netscape Navigator. It uses Geecko web engine in all the supported platforms leaving the latest one on i. OS which doesnt use Geecko. Features supported by Firefox include tabbed browsing, spell checking, incremental find, live bookmarking, private browsing, add on support which allows easy integration of many features. Apart from these, it supports many standards including HTML4, XML, XHTML, SVG and APNG etc. It has been one of the popular web browsers in many Asian and African countries with more than a billion users around the world. Firefox Browser. 3. Opera. Another popular web browser, Opera is one of the earliest one we have till date, with initial version released in 1. It is written in C with availability marked for all Operating Systems including Windows, OS, Linux, OS X, Symbian and Mobile phones including Android, i. OS. It uses Blink web engine, whereas earlier versions used Presto. Features of this browser include speed dial for quick search, tabbed browsing, downloads manager, Page Zooming which allows Flash, Java and SVG to be increased or decreased as per user requirements, deletion of HTTP cookies, browsing history and other data on click of a button. Despite of its criticism for compatibility, and other UI related issues, it has been one of the favourite browsers with total of around 2. Opera Browser. 4. Chromium. Widely known web browser, which forms the base from where Google Chrome takes its source code, Chromium is another Open Source web browser available for Linux, Windows, OS X and Android Operating Systems. It is mainly written in C with latest release being in December 2. It is designed with minimalistic user interface so as to make it lightweight and fast. Features of Chromium include a tabbed window manager, support for Vorbis, Theora, Web. M codecs for HTML5 Audio and Video, Bookmark and History and Session management. Apart from Google Chrome, Chromium also forms base for large number of other Web Browsers some of which are still active while others have been discontinued. Some of them are Opera, Dartum, Epic Browser, Vivaldi, Yandex Browser, Flock discontinued, Rockmelt discontinued and many more. Chromium Browser. Midori. Midori is an open source web browser developed In Vala and C with Web. Kit engine and GTK 2 and GTK 3 interface. With initial stable release in 2. August 2. 01. 5, Midori is currently the default browser in many Linux distros including Manjaro Linux, elementary OS, Sli. Taz Linux, Bodhi Linux, Trisqel Mini, System. Rescue CD, old versions of Raspbian. Major Features provided by it include HTML5 Support, Bookmark Management, Private Browsing, Windows, Tabs and Sessions management, Speed Dial, Easy integration of extensions which can be written in C and Vala, Unity Support. Midori has been mentioned as one of the alternative web browsers for Linux by Life. Hacker and many other sites including Tech. Radar, Computer. World and Gigaom. Midori Browser. 6. Qup. Zilla. Qup. Zilla is another known web browser which started merely as a Research Project with first release in December 2. Python, and later releases being in C with goal to develop a portable web browser. It is licensed under GPLv. Linux, Windows, OS X, Free. BSD. Qup. Zilla uses Web. Kit engine with Qt. Web. Kit to be in sync with mordern web standards. It provides all the functions of a mordern web browser including Speed Dial, built in Add Block feature, bookmark management, etc. Additional features which would make you opt this browser include Performance Optimization with memory consumption lower than most famous web browsers including Firefox and Google Chrome. Qupzilla Browser. Konqueror. Another multi purpose Web Browser and File Manager, Konqueror is another one in the list. Developed in CQt and available for Operating Systems including Linux and Windows and licensed under GPLv. As the name shows, Konqueror starting with K is the default browser for KDE Desktop environment, replacing the then known KFM. As a web browser, it uses KTML derived web rendering engine and also supports Java. Script, Java applets, CSS, Jquery. Its rendering abilities are unquestionable and better than most web browsers which highlights its performance optimization.

var q coreldraw11freedownloadPaint Program Sketch, Draw, Paint with Painter Essentials 5. Mind blowing brushes and painting tools. Prepare to be amazed by revolutionary brushes and art tools that mimic real oil paints, chalks, charcoal, watercolor and other media so closely, youll forget youre on a computer. Craft your own characters, scenery and original artwork in just a few exhilarating strokesCorel Draw x8 Serial Number 2017 Keygen Full Version Free Download reveals an enormous amount of inventive potentials with crack and enhanced tools. Mystical Modules FX Gen2 Over 100 Professional Photo Enhancement Effects and Tools Used In Post Production Photo Enhancement Contains 11 Effect Modules. Corel draw x4 free download Corel PaintShop Pro, Corel Painter 2016, SignTools for Corel Draw, and many more programs. Developer of plugins including PhotoGraphic Edges, Mystical Lighting, Mystical Tint Tone and Color, AutoEye, and Dreamsuite Series.

var q excel2007openingthevbaprojectinthisfileSimplify your reporting by using VBA to export your Excel dashboards to PowerPoint with ease. VBA Interview Questions and Answers with Examples Please find the below basic Object model of Excel. Application Workbooks Worksheets Range Chart A macro is nothing but set of instructions which are stored in Visual Basic module in a VBA Editor. It helps in automating common repetitive tasks on daily, weekly or monthly basis by running macro. Using macros, you can save lot of time, increase productivity and on time delivery to customers. You can use the AltF1. VBA editor screen Please find the following steps to stop recording macro in the workbook. Step 1 Go To Developer tab from the main ribbon of Excel window. Step 2 Click on Stop Recording command button to stop from the recording macro. Please find the following steps to delete macros from the workbook. Step 1 Go To Developer tab from the main ribbon of Excel window. Step 2 Click on the Macros command button to see the available macros in the active workbook. Step 3 Once you click on the Macros command button, Macro dialog box will appear on the screen. Step 4 Select macro name which you want to delete macro and then click on Delete command button. Step 5 Now, It will show the confirmation dialog box. Click on Ok to delete the macro. This is one of the most commonly asked Excel VBA Interview Questions and Answers. You can use WorkbookOpen Event to run macros automatically in Excel VBA while opening Workbook. To get WorkbookOpen Event in Excel, please find the following steps. Go To VBA Editor. Click on This. Workbook from the Project Explorer. Now, you can see two drop down lists in the right side. Select Workbook from the first drop down list and then choose Open from the second drop down list. Now, you can see the following code. Private Sub WorkbookOpen Your Statements. End Sub 6. You can add the code in between the above lines to run a macro. Save and close the workbook. Now, reopen the workbook to test the macro. Example Private Sub WorkbookOpen Msg. Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro. VBA Interview Questions and Answers with Top 100 Examples, Download Free PDF File. Basic, Advanced for Freshers Experienced Excel, Access Developers. Visual Basic for Applications VBA is an implementation of Microsofts eventdriven programming language Visual Basic 6, which was discontinued in 2008, and its. Pardon English It appears that saving the xlsm as an xlsb in 2007 and then opening it and retaining the xlsb extension in 2010 can obivate this problem. You should already have Microsoft Excel version 2003, 2007, 2010, 2013 or 2016. Obviously the newer the better, but VBA works the same in all versions. Preventing autoopen and WorkbookOpen events from running Introduction. As a fulltime developer I oftentimes open files containing VBA and want to be able to run code. Frank Rice, Microsoft Corporation. May 2006. Applies to 2007 Microsoft Office Suites, Microsoft Office Excel 2007, Microsoft Office PowerPoint 2007, Microsoft Office. Excel VBA tutorials and training. Learn how to use Visual Basic for Applications in Microsoft Excel now. Box Workbook has Opened Successfully., vb. Information End Sub In the above example, the macro will run automatically when we are opening workbook. Now, it will display message like Workbook has Opened Successfully. Or we can also define a procedure named AutoOpen in any code module, this will execute while opening the macro file. You can use WorkbookOpen Event to show User. Form automatically in Excel VBA when we open Workbook. To get WorkbookOpen Event in Excel, please find the following steps. Go To VBA Editior. Click on This. Workbook from the Project Explorer. Now, you can see two drop down lists in the right side of the VBA Editor window. Select Workbook from the first drop down list and then choose Open from the second drop down list. Now, you can see the following code. Private Sub WorkbookOpen Your Statements. End Sub 6. You can add the code in between the above lines to run a macro. Save and close the workbook. Now, reopen the workbook to test the macro. Example Private Sub WorkbookOpen Here My. Form is the User. Form name. My. Form. Show End Sub In the above example, the macro will show the User. FormNamed My. Form automatically when we open Workbook. Note Before running above macro add User. Form and then assign the name of the User. Form to My. Form. By. Val vs By. Ref in VBA is also one of the most frequently asked Excel VBA Interview Questions and Answers. By. Val Specifies that an argument is passed in such a way that the called procedure or property cannot change the value of a variable underlying the argument in the calling code. By. Ref Specifies that an argument is passed in such a way that the called procedure can change the value of a variable underlying the argument in the calling code. Note Default value is By. Ref. It is good practice to include the By. Ref declaration if you are going to change the value of the parameter. Please find the different looping statements which are available in Excel VBA. For. Next loop, Do While. Loop, Do until Loop, Do. Loop Until. ,Do While NotLoop, While. Wend loop Please find the following steps to add User. Form or Module or Class Module to the VBA Project. Add User. Form Step 1 Go To Insert menu in the VBA Editor window. Step 2 Click on User. Form to add to the Project. Now you can see added User. Form in the Project Explorer. Default User. Form name will be User. Form. 1. You can change the User. Form name with using properties. Add Module Step 1 Go To Insert menu in the VBA Editor window. Step 2 Click on Module to add to the Project. Now you can see added Module in the Project Explorer. Default module name will be Module. You can change the module name with using properties. Add Class Module Step 1 Go To Insert menu in the VBA Editor window. Step 2 Click on Class Module to add to the Project. Now you can see added Class Module in the Project Explorer. Default Class module name will be Class. You can change the class module name with using properties. We can create object variable and it can use in entire procedure. Please find the following examples to create object for workbook, worksheet, etc. Create object for Workbook Sub CreateObjectWorkbook Dim Wb As Workbook Set Wb Active. Workbook Msg. Box Wb. Sheets1. Name End Sub Explanation In the above example, I have created and assigned to Active Workbook to Wb objet. And then I have used it in the next statementMsg. Box Wb. Sheets1. Name to display first worksheet name. An array is a set of variables that are similar type. Using an array, you can refer to a specific value of an array by using array name and the index number also called subscript. We can create and define size of an array variable in the following way. Dim Array. Name Index. Number As Datatype. Example Dim a. Value2 As Integer. In the above statement a. Value is an array name and 2 indicates an array size. We can assign values to an array in the following way. Declare an array variable. Dim a. Value 2 As Integera. Value0firsta. Value1 Seconda. Value2 ThirdOr. Dim a. Value As Integer first ,Second,ThirdData Type A data type tells, what kind of variable we are going to use in a procedure or function. The information that specifies how much space a variable needs called a data type. Before using variable, we need to know how much space the variable will occupy in memory, because different variables occupy different amount of space in memory. We can declare the variable in the following way. Dim Variable. Name as Datatype. Example Dim i. Cnt as Integer. Where i. Cnt represents Variable. Name and Integer represents Datatype. The following are different data types which are available in Excel VBA. Byte, Boolean, Integer, Long, Single, Double, Currency, Decimal, Date, Object, String, Variant and User defined data types. For more information please find the following link. Read More User. Form Controls Button, Combo Box, Check Box, Spin Button, List Box, Option Button, Group Box, Label, Scroll Bar, etc. Active. X Controls Command Button, Combo Box, Check Box, List Box, Text Box, Scroll Bar, Spin Button, Option Button, Label, Image, Toggle Button. Please find the following steps to assign macro to a button. Step 1 Go to the Developer tab from the excel ribbon menu, go to Forms Control group. Step 2 Click on Button from the Form Controls. Step 3 Click the worksheet location where you want the button to appear. Step 4 Drag the button in the sheet. Step 5 Right click on the button, click on Assign Macro.