• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

2 Visual Basic Analysis courses in Liverpool

Microsoft Excel Macros & VBA - In-company

By Microsoft Office Training

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Certificates Certificates Certificate of completion Digital certificate - Included

Microsoft Excel Macros & VBA - In-company
Delivered in London or UK Wide or OnlineFlexible Dates
£750

Complete VB.NET programming

5.0(3)

By Systems & Network Training

Complete VB.Net training course description A hands on introduction to programming in Visual BASIC .Net. What will you learn Build Visual BASIC applications. Build simple components Debug Visual BASIC programs. Examine existing code and determine its function. Complete VB.Net training course details Who will benefit: Anyone wishing to program in Visual BASIC. Anyone wishing to build Windows based applications. Prerequisites: None although experience in another high level language would be useful. Duration 5 days Complete VB.Net training course contents Writing your first program Visual Studio, forms designer, running VB programs, the UI, properties, writing the code. Toolbox Controls Basic use, input controls, ActiveX controls. Menus and Dialog Boxes Menus, Dialog Box controls, event procedures. Visual Basic .NET variables and operators Variables, I/O, data types, constants, operators, Math Methods, precedence. Decision Structures and Loops and Timers Event-Driven programming, If…Then, Select Case, For…Next Loops, Timer Control. Debugging Visual Basic .NET Programs Break Mode, watch & command windows. Structured Error Handling Try...Catch, Finally, Err Object, retry periods. Modules and Procedures Standard modules, public variables, procedures. Arrays and Collections to Manage Data Fixed-Size & dynamic Arrays, ReDim Preserve, object collections, Controls Collection. Text Files and String Processing Text Box object, Text String methods, sorting. Automating Office Applications Application objects, automation in VB, the Object Browser, the Process Component. Deploying Visual Basic .NET Applications Planning a deployment, ways to deploy an application, deployment projects, options. Managing Windows Forms Forms, positioning, manipulation, adding controls, organizing controls, Startup Object. Adding Graphics and Animation Effects System.Drawing namespace, coordinates, SystemPaint Event, animation, transparency. Inheriting Forms and Creating Base Classes Inheriting forms, inheritance picker, base classes and inheritance, classes in projects. Working with Printers PrintDocument class, Text Box object, Print Preview and Page Setup Dialog Boxes. Database programming with ADO.NET Databases, ADO.NET, Data Adapters, Datasets, Bound & Navigation Controls. Displaying database records, formatting DataGrid cells, updating the database. Displaying HTML Documents Using IE IE Object, Internet Controls, IE Events. Web Forms for Interactive Web Applications ASP.NET, Web Forms vs. Windows Forms, HTML controls, web applications, event procedures for web forms controls.

Complete VB.NET programming
Delivered in Internationally or OnlineFlexible Dates
£3,697

Online Options

Show all 31

Visual Basic and VBScript Masterclass

By Course Cloud

Course Overview Visual Basic is one of the most powerful languages created by one of the largest companies in the world, Microsoft.  In this Visual Basic and VBScript Masterclass, you will learn the basic and advanced functions of Visual Basic - from how to get set up on Windows, to understanding the different data types. It will show you how to perform a wide range of tasks, from working with constructors and destructors, to object orientated programming. Throughout the training, you will be developing your basic programming skills and, which will help you to gain a head start in securing a career in this competitive field. You will gain all the knowledge needed to leverage the incredible technology behind this powerful programming language. This best selling Visual Basic and VBScript Masterclass has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Visual Basic and VBScript Masterclass is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Visual Basic and VBScript Masterclass is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Visual Basic and VBScript Masterclass is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Visual Basic and VBScript Masterclass, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Visual Basic and VBScript Masterclass will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Visual Basic and VBScript Masterclass to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Visual Basic and VBScript Masterclass
Delivered Online On Demand
£25

Visual Basic and VBScript Training

4.5(3)

By Studyhub UK

The 'Visual Basic and VBScript Training' course is a comprehensive program that equips learners with the skills to create and manipulate software applications using Visual Basic (VB) and VBScript. Participants will delve into the fundamental concepts, advanced techniques, and graphical user interface (GUI) development, enabling them to build interactive and user-friendly applications. This course covers a range of topics, from basic scripting to advanced resource management, empowering learners to harness the power of these programming languages for various software development needs. Learning Outcomes: Gain proficiency in creating and manipulating software applications using Visual Basic. Understand the core concepts of classes and their role in application development. Explore file handling techniques for efficient data management. Develop graphical user interfaces (GUI) for user-friendly application interaction. Implement dialog boxes to enhance user experience and gather input. Learn advanced scripting techniques to optimize application functionality. Utilize resource management techniques for efficient application design. Develop proficiency in VBScript for creating dynamic web pages and scripting actions. Why buy this Visual Basic and VBScript Training? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Visual Basic and VBScript Training there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Visual Basic and VBScript Training does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Aspiring software developers looking to learn Visual Basic and VBScript. Programmers seeking to expand their knowledge of application development. Web developers interested in using VBScript for dynamic web content. IT professionals looking to enhance their scripting and programming skills. Prerequisites This Visual Basic and VBScript Training was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Software Developer - Median salary of $110,000 - $120,000 per year. Web Developer - Median salary of $75,000 - $85,000 per year. Application Developer - Median salary of $90,000 - $100,000 per year. Systems Analyst - Median salary of $80,000 - $90,000 per year. IT Consultant - Median salary of $90,000 - $100,000 per year. Course Curriculum Section 01: Introduction Introduction To This Course 00:02:00 Setup On Windows 00:06:00 Run Code Online 00:01:00 Section 02: Basics Console Output 00:04:00 Comments 00:03:00 Variables 00:03:00 Console Input 00:02:00 Data Types 00:08:00 Constants 00:03:00 Enumerations 00:04:00 Directives 00:05:00 Operators 00:06:00 If Statement 00:05:00 Switch Statement 00:04:00 Loops 00:08:00 Strings 00:05:00 Date & Time 00:04:00 Arrays 00:06:00 For Each Loop 00:04:00 ArrayList 00:04:00 Hashtable 00:05:00 SortedList 00:03:00 Stack 00:05:00 Queue 00:04:00 Subs 00:07:00 Functions 00:04:00 Exception Handling 00:05:00 Section 03: Classes Simple Class Example 00:09:00 Constructor 00:03:00 Destructor 00:03:00 Shared Properties 00:04:00 Inheritance 00:04:00 Scope 00:03:00 Section 04: File Handling File Handling 00:07:00 Section 05: GUI Setup A GUI Project 00:03:00 Forms 00:05:00 TextBox 00:06:00 Label 00:02:00 Button 00:04:00 ListBox 00:04:00 ComboBox 00:03:00 RadioButton 00:04:00 CheckBox 00:02:00 DateTimePicker 00:03:00 PictureBox 00:03:00 ProgressBar 00:03:00 GroupBox 00:04:00 TreeView 00:04:00 ListView 00:02:00 Events 00:03:00 Section 06: Dialog Box Color Dialog 00:03:00 Font Dialog 00:03:00 Open File Dialog 00:03:00 Save File Dialog 00:05:00 Print Dialog 00:03:00 Section 08: Resource Menus 00:02:00 Anchoring & Docking 00:04:00 Modals 00:03:00 Regular Expressions 00:09:00 Parsing an XML File 00:06:00 Section 07: Advanced Resource - Visual Basic and VBScript Training 00:00:00 Assignment Assignment - Visual Basic and VBScript Training 00:00:00

Visual Basic and VBScript Training
Delivered Online On Demand4 hours 9 minutes
£10.99

Excel VBA/Macros Foundations

4.8(9)

By Skill Up

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Excel VBA/Macros Foundations
Delivered Online On Demand8 hours 53 minutes
£25

Visual Merchandising Training Course

4.7(160)

By Janets

Learn visual merchandising best practices with our comprehensive online course. Master retail display design, window dressing, store layouts, promotional techniques, and more. Develop creative skills to increase sales and customer engagement. Gain industry-recognized expertise to start or advance your retail merchandising career.

Visual Merchandising Training Course
Delivered Online On Demand1 hour
£9.99

Programming and Data Wrangling with VBA and Excel

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - Using VBA to Solve Business Problems Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects

Programming and Data Wrangling with VBA and Excel
Delivered OnlineFlexible Dates
£885

VBA with Microsoft Excel

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Write VBA code to create VBA subroutines and functions. Use various programming elements to solve problems through code, including variables,objects, conditional statements, and loops. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code. Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365 (Desktop or Online) courses, Parts 1, 2, and 3. 1. Using VBA to Solve Business Problems Use Macros to Automate Tasks in Excel Identify Components of Macro-Enabled Workbooks Configure the Excel VBA Environment 2. Recording a Macro Use the Macro Recorder to Create a VBA Macro Record a Macro with Relative Addressing Delete Macros and Modules Identify Strategies for Using the Macro Recorder 3. Writing VBA Code Directly Write VBA Code Discover Objects You Can Use Create a Custom Function 4. Solving Problems through Code Make Decisions in Code Work with Variables Perform Repetitive Tasks 5. Improving Your VBA Code Debug VBA Errors Deal with Errors Improve Macro Performance 6. Controlling How and When Macros Run Prompt the User for Information Configure Macros to Run Automatically Additional course details: Nexus Humans VBA with Microsoft Excel (v1.2) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the VBA with Microsoft Excel (v1.2) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

VBA with Microsoft Excel
Delivered OnlineFlexible Dates
£655

Microsoft Excel Macros & VBA - Online classroom

By Microsoft Office Training

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classroom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Microsoft Excel Macros & VBA - Online  classroom
Delivered OnlineFlexible Dates
£550

Hands on Programming on AutoCAD to Excel Using VB.NET

4.7(160)

By Janets

Description Register on the Hands on Programming on AutoCAD to Excel Using VB.NET today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a certificate as proof of your course completion. The Hands on Programming on AutoCAD to Excel Using VB.NET course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablets, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With This Course Receive a digital certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Certificate of Achievement After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.  Method of Assessment You need to attend an assessment right after the completion of this course to evaluate your progression. For passing the assessment, you need to score at least 60%. After submitting your assessment, you will get feedback from our experts immediately. Who Is This Course For The course is ideal for those who already work in this sector or are aspiring professionals. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge.   Course Content Section 01: Introduction Introduction - Hands on Programming on AutoCAD to Excel Using VB.NET 00:04:00 Who is this course for? - Hands on Programming on AutoCAD to Excel Using VB.NET 00:02:00 What will you learn from this course? - Hands on Programming on AutoCAD to Excel Using VB.NET 00:05:00 Tools needed 00:01:00 Course Prerequisites 00:04:00 Section 02: Exporting AutoCAD Objects to Excel Section Overview - Export AutoCAD Objects to Excel 00:02:00 Exporting Lines to Excel - Overview 00:02:00 Creating the VB.NET-Excel Project 00:06:00 Design of User Interface to Export Lines 00:10:00 Creating the Common Utility Class 00:19:00 Creating the ExportLines Method 00:12:00 Running and Testing ExportLines Method 00:06:00 Exporting MTexts to Excel - Overview 00:02:00 Creating the ExportMTexts Method 00:11:00 Export Polylines to Excel - Overview 00:01:00 Creating the ExportPolylines Method 00:12:00 Running and Testing ExportPoylines Method 00:12:00 Exporting Blocks (With Attributes) to Excel - Overview 00:02:00 Creating the ExportBlocks Method 00:12:00 Creating Export Blocks UI and Running the Code 00:06:00 Exporting Blocks (With Attributes) to Excel - Overview 00:02:00 Creating the User Interface for exporting Blocks to Excel 00:05:00 Creation of BlocksForm UI 00:04:00 Coding the BlocksForm Load Event 00:08:00 Testing the BlocksForm UI 00:03:00 Coding the BlocksForm to populate the Listboxes 00:15:00 Coding the BlocksForm Export Button 00:04:00 Coding the ExportBlocksWithAttributes Method 00:21:00 Running and Testing ExportBlocksWithAttributes Method 00:02:00 Section 03: Importing Excel File into AutoCAD Section Overview - Import Excel File into AutoCAD 00:01:00 Importing Lines from Excel File into AutoCAD - Overview 00:01:00 Creating ImportExcelUtil Class 00:02:00 Creating the ImportLines Method 00:19:00 Creating the UI for the ImportLines Method 00:02:00 Coding the ImportLines UI code behind. 00:07:00 Running and Testing ImportLines Method 00:08:00 Importing MTexts into AutoCAD - Overview 00:01:00 Creating the ImportMTexts Method 00:11:00 Creating ImportMTexts User Interface 00:02:00 Running and Testing ImportMTexts Method 00:02:00 Importing Polylines from Excel File into AutoCAD - Overview 00:01:00 Creating the ImportPolylines Method 00:14:00 Creating ImportPolylines User Interface 00:02:00 Running and Testing ImportPolylines Method 00:03:00 Importing Blocks (without Attributes) from Excel File into AutoCAD - Overview 00:01:00 Creating the ImportBlocks Method 00:09:00 Creating the ImportBlocks User Interface 00:02:00 Running and Testing ImportBlocks Method 00:03:00 Importing Blocks (with Attirubtes) from Excel File into AutoCAD - Overview 00:01:00 Creating the ImportBlocksWithAttributes Method 00:25:00 Creating the UI for ImportBlocksWithAttributes Method 00:04:00 Running and Testing ImportBlocksWithAttributes Method 00:03:00 Section 04: Exporting AutoCAD Objects to a File Exporting Lines to a File - Overview 00:02:00 Creating the ExportToFile Utility Class 00:04:00 Creating ExportLinesToFile Method 00:14:00 Creating the UI for ExportLinesToFile Method 00:08:00 Running and Testing ExportLinesToFile Method 00:02:00 Exporting MTexts to File - Overview 00:01:00 Creating the MTextToFile Method 00:06:00 Creating the UI for the ExportMTextToFile Method 00:01:00 Running and Testing ExportMTextToFile Method. 00:08:00 Exporting Polylines to File - Overview 00:02:00 Creating ExportPolylinesToFile Method 00:11:00 Exporting Polylines to File - User Interface 00:01:00 Running and Testing ExportPolylinesToFile Method 00:02:00 Exporting Blocks (without Attributes) to File - Overview 00:02:00 Creating the ExportBlocksToFile Method 00:11:00 Creating ExportBlocksToFile User Interface 00:02:00 Running and Testing ExportBlocksToFile Method 00:02:00 Exporting Blocks (With Attributes) to a File - Overview 00:02:00 Creating the EXportBlocksWithAttributesToFile Method 00:19:00 Creating the UI for ExportBlocksWithAttributesToFile Method 00:06:00 Coding the BlocksForm for ExportBlocksWithAttributeToFile Method 00:04:00 Running and Testing ExportBlocksWithAttributesToFile Method 00:03:00 Section 05: Importing Text File into AutoCAD Importing Text File into AutoCAD - Overview 00:01:00 Importing Lines from a Text File into AutoCAD - Overview 00:02:00 Creating the ImportFileUtil Class 00:01:00 Creating the ImportLinesMethod 00:17:00 Creation of ImportLines User Interface 00:03:00 Coding the ImportLines UI button 00:05:00 Running and Testing the ImportLines Method 00:04:00 Importing MTexts from Text File into AutoCAD - Overview 00:02:00 Creating the ImportMTexts Method 00:09:00 Creating the TextStyle Manipulation Code 00:02:00 Creating the UI for the ImportMTexts Method 00:01:00 Running and Testing the ImportMTexts Method 00:04:00 Importing Polylines from a Text File into AutoCAD - Overview 00:02:00 Creating the ImportPolylines Method 00:18:00 Creating the ImportPolylines UI 00:02:00 Running and Testing ImportPolylines (from a File) Method 00:02:00 Importing BLocks (without Attributes) from a Text File into AutoCAD - Overview 00:02:00 Creating the ImportBlocks (without Attributes) Method 00:15:00 Creating the ImportBlocks UI 00:05:00 Running and Testing ImportBlocks (without Attributes) Method 00:04:00 Importing Blocks (with Attributes) from a Text File into AutoCAD - Overview 00:02:00 Creating the ImportBlocksWithAttributes from a File Method 00:24:00 Creating the ImportBlocksWithAttributes (from a File) UI (Part 1) 00:06:00 Creating the ImportBlocksWithAttributes (from a File) UI (Part 2) 00:04:00 Running and Testing ImportBlocksWithAttributes (from a File) Method 00:03:00

Hands on Programming on AutoCAD to Excel Using VB.NET
Delivered Online On Demand9 hours 32 minutes
£25

Learn AutoCAD Programming using VB.NET - Hands On!

4.5(3)

By Studyhub UK

The course 'Learn AutoCAD Programming using VB.NET - Hands On!' provides comprehensive training in using VB.NET to program and automate tasks in AutoCAD. It covers essential concepts, components of the AutoCAD .NET API, creating and manipulating AutoCAD objects, exploring AutoCAD dictionaries, user interactions, selection sets, and developing practical projects. Participants will gain the necessary skills to efficiently create custom plugins and enhance their productivity in AutoCAD. Learning Outcomes: Understand the fundamentals of VB.NET programming and its relevance to AutoCAD. Explore the AutoCAD .NET API components and learn to work with the AutoCAD object hierarchy. Create and manipulate various AutoCAD objects such as lines, circles, polylines, and more using VB.NET. Implement AutoCAD dictionaries to manage layers, line types, text styles, and other entities. Utilize user interactions for input and output in VB.NET, enhancing the user experience. Work with selection sets and filters to efficiently select and process AutoCAD objects. Develop hands-on projects, including a BlocksCounter plugin and an ObjectExtractor plugin, to reinforce learning and practical application. Why buy this Learn AutoCAD Programming using VB.NET - Hands On!? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Learn AutoCAD Programming using VB.NET - Hands On! there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Learn AutoCAD Programming using VB.NET - Hands On! does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Prerequisites This Learn AutoCAD Programming using VB.NET - Hands On! was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Learn AutoCAD Programming using VB.NET - Hands On! is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Unit 01: Introduction Module 01: Course Outline 00:05:00 Module 02: Introduction 00:01:00 Module 03: Who is this Course for? 00:01:00 Module 04: What will I learn from this Course? 00:01:00 Module 05: What is VB.NET? 00:01:00 Module 06: What is AutoCAD .NET API? 00:01:00 Module 07: What are the advantages of programming in AutoCAD .NET API? 00:01:00 Module 08: Hands-on Projects overview 00:06:00 Unit 02: Exploring AutoCAD .NET API Components Module 01: AutoCAD .NET API Components Overview 00:01:00 Module 02: AutoCAD .NET API Assemblies 00:02:00 Module 03: Understanding AutoCAD Object Hierarchy 00:03:00 Module 04: AutoCAD .NET API Application Object 00:02:00 Module 05: AutoCAD .NET API Document Object 00:02:00 Module 06: AutoCAD .NET API Database Object 00:04:00 Unit 03: Hello AutoCAD from VB.NET Module 01: Section Overview 00:04:00 Module 02: Installing Visual Studio 2019 00:05:00 Module 03: Setting up Visual Studio 2019 Integrated Development Environment (IDE) 00:04:00 Module 04: Creating First VB.NET Plugin (Hello AutoCAD) 00:12:00 Module 05: Different ways to communicate with the User 00:04:00 Module 06: Configuring VS2019 Target Processor 00:10:00 Unit 04: Creating AutoCAD Objects using VB.NET Module 01: Creating AutoCAD Object using VB.NET Overview 00:01:00 Module 02: Creating DrawObjects Project 00:04:00 Module 03: Creating a Line Object using VB.NET 00:15:00 Module 04: Creating a MText Object using VB.NET 00:12:00 Module 05: Creating a Circle Object using VB.NET 00:09:00 Module 06: Creating an Arc Object using VB.NET 00:07:00 Module 07: Creating a Polyline Object using VB.NET 00:08:00 Module 08: Creating Multiple Circles Vertically 00:09:00 Module 09: Creating Multiple Circles Horizontally 00:05:00 Unit 05: Manipulating AutoCAD Objects using VB.NET Module 01: Manipulating AutoCAD Objects Overview 00:01:00 Module 02: Creating the Project ManipulateObjects 00:04:00 Module 03: Creating the SingleCopy Method 00:13:00 Module 04: Creating the MultipleCopy Method 00:11:00 Module 05: Creating the EraseObject Method 00:12:00 Module 06: Creating the MoveObject method 00:07:00 Module 07: Creating the MirrorObject method 00:10:00 Module 08: Creating the RotateObject method 00:07:00 Module 09: Creating the ScaleObject method 00:05:00 Module 10: Creating the OffsetObject method 00:05:00 Unit 06: Exploring AutoCAD Dictionaries using VB.NET Module 01: Exploring AutoCAD Dictionaries - Overview 00:02:00 Module 02: Creating LayersLineTypesAndStyles Project 00:06:00 Module 03: Creating the ListLayers Method 00:11:00 Module 04: Creating the CreateLayer Method 00:10:00 Module 05: Creating the UpdateLayer Method 00:12:00 Module 06: Creating the SetLayerOnOff Method 00:08:00 Module 07: Creating the SetLayerFrozenOrThaw Method 00:04:00 Module 08: Creating the DeleteLayer Method 00:05:00 Module 09: Creating the LockUnlockLayer Method 00:04:00 Module 10: Creating the SetLayerToObject Method 00:08:00 Module 11: Creating the ListLineTypes Method 00:09:00 Module 12: Creating the LoadLineType Method 00:07:00 Module 13: Creating the SetCurrentLineType Method 00:05:00 Module 14: Creating the DeleteLineType Method 00:09:00 Module 15: Creating the SetLineTypeToObject Method 00:05:00 Module 16: Exploring TextStyles - Overview 00:01:00 Module 17: Creating the ListStyles Method 00:08:00 Module 18: Creating the UpdateCurrentTextStyleFont Method 00:12:00 Module 19: Creating the SetCurrentTextStyle Method 00:08:00 Module 20: Creating the SetTextStyleToObject Method 00:08:00 Unit 07: User Interactions in VB.NET Module 01: User Input Functions - Overview 00:02:00 Module 02: Creating the UserInteractions Project 00:03:00 Module 03: Creating the GetName Method 00:11:00 Module 04: Creating the SetLayer Method using the GetString function 00:12:00 Module 05: Creating the CreateLineUsingGetpoint Method 00:11:00 Module 06: Creating the CalculateDefinedArea Method 00:17:00 Module 07: Creating the DrawObjectsUsingGetKeywords Method 00:14:00 Module 08: Creating the GetDistanceBetweenTwoPoints Method 00:05:00 Module 09: Creating the CountObjects Method 00:15:00 Unit 08: Selection Sets and Filters Module 01: Selection Sets and Filters - Overview 00:13:00 Module 02: Creating the SelectionSets Project 00:05:00 Module 03: Creating the SelectAllAndChangeLayer Method 00:12:00 Module 04: Creating the SelectObjectOnScreen Method 00:08:00 Module 05: Creating the SelectWindowAndChangeColor Method 00:06:00 Module 06: Creating the SelectCrossingAndDelete Method 00:05:00 Module 07: Creating the SelectFenceAndChangeLayer Method 00:06:00 Module 08: Creating the CountPickFirstSelection Method 00:07:00 Module 09: Creating the SelectLines Method 00:13:00 Module 10: Creating the SelectMTexts Method 00:05:00 Module 11: Creating the SelectPlines Method 00:04:00 Module 12: Creating the SelectWalls Method 00:07:00 Module 13: Creating the SelectStairs Method 00:03:00 Module 14: Creating the SelectFrenchDoors Method 00:04:00 Module 15: Creating the SelectBifoldDoors Method 00:03:00 Module 16: Creating CountReceptacles Method 00:04:00 Module 17: Creating the CountLightingFixtures Method 00:10:00 Unit 09: Developing Projects - Hands On Module 01: Developing Projects - Hands on Overview 00:02:00 Module 02: BlocksCounter Plugin Demo 00:03:00 Module 03: Creating the BlocksCounter Project 00:04:00 Module 04: Creating the CountBlocksToTable Method 00:08:00 Module 05: Creating the PromptUser Function 00:08:00 Module 06: Creating the GatherBlocksAndDrawTable Method 00:12:00 Module 07: Continuation of GatherBlocksAndDrawTable Method 00:17:00 Module 08: Running and Debugging the BlocksCounter Project - Part 1 00:15:00 Module 09: Running and Debugging the BlocksCounter Project - Part 2 00:11:00 Module 10: Running and Debugging the BlocksCounter Project - Part 3 00:01:00 Module 11: Creating the ObjectExtractor Plugin Project 00:04:00 Module 12: Creating the ExtractObjects Method 00:07:00 Module 13: Creating the ExtractLine Method 00:16:00 Module 14: Running and Debugging the ExtractLine Method 00:05:00 Module 15: Creating the ExtractCircle Method 00:11:00 Module 16: Creating the ExtractMText Method 00:13:00 Module 17: Creating the ExtractPolyline Method 00:19:00 Module 18: Creating the ExtractBlock Method 00:10:00 Unit 10: Conclusion Module 01: Congratulations and Thank you very much! 00:01:00 Assignment Assignment - Learn AutoCAD Programming using VB.NET - Hands On! 00:00:00

Learn AutoCAD Programming using VB.NET - Hands On!
Delivered Online On Demand12 hours 9 minutes
£10.99