Name: Learn AutoCAD Programming using VB.NET - Hands On!
Price: 10.99 GBP
Availability: InStock

<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2><b>Course Overview</b></h2>		</div>
				</div>
				<div>
				<div>
					<div><p><span>Visual Basic is one of the most powerful languages created by one of the largest companies in the world, Microsoft. </span></p><p><span>In this</span><b> Visual Basic and VBScript Masterclass</b><span>, 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.</span></p><p><span>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.</span></p></div>
				</div>
				</div>
				<div>
				<div>
					<div><p>This best selling <strong>Visual Basic and VBScript Masterclass </strong>has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth <strong>Visual Basic and VBScript Masterclass </strong>is suitable for anyone who wants to build their professional skill set and improve their expert knowledge.</p><p>The <strong>Visual Basic and VBScript Masterclass </strong>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 <strong>Visual Basic and VBScript Masterclass </strong>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.</p><p>After successfully completing the<strong> Visual Basic and VBScript Masterclass</strong>, 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 <strong>Visual Basic and VBScript Masterclass </strong>will help you stand out from the crowd. You can also validate your certification on our website.</p><p>We know that you are busy and that time is precious, so we have designed the <strong>Visual Basic and VBScript Masterclass </strong>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. </p><p>Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.</p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div><div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
					</div>
		</div>
								</div>
					</div>

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.

Course Cloud

Visual Basic

Microsoft Certification

Visual Basic Analysis

Microsoft Virtual Academy (MVA)

Computer Programming

Trainers Course

Visual Basic and VBScript Masterclass

General Admission

<div>
						<div>
				<div>
									<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
								<div>
				<p><span>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.</span></p><p><b id="docs-internal-guid-7d96eed5-7fff-ceb0-8984-5aa033ce8438"><br /></b></p><p><span>Learning Outcomes:</span></p><ul><li><p><span>Gain proficiency in creating and manipulating software applications using Visual Basic.</span></p></li><li><p><span>Understand the core concepts of classes and their role in application development.</span></p></li><li><p><span>Explore file handling techniques for efficient data management.</span></p></li><li><p><span>Develop graphical user interfaces (GUI) for user-friendly application interaction.</span></p></li><li><p><span>Implement dialog boxes to enhance user experience and gather input.</span></p></li><li><p><span>Learn advanced scripting techniques to optimize application functionality.</span></p></li><li><p><span>Utilize resource management techniques for efficient application design.</span></p></li><li><p><span>Develop proficiency in VBScript for creating dynamic web pages and scripting actions.</span></p></li></ul><p><b><br /></b></p><h3><span>Why buy this Visual Basic and VBScript Training?</span></h3><ul><li><p><span>Unlimited access to the course for forever</span></p></li><li><p><span>Digital Certificate, Transcript, student ID</span><span> all included in the price</span></p></li><li><p><span>Absolutely no hidden fees</span></p></li><li><p><span>Directly receive </span><span>CPD </span><span>accredited qualifications after course completion</span></p></li><li><p><span>Receive one to one assistance on every weekday from professionals</span></p></li><li><p><span>Immediately receive the PDF certificate after passing</span></p></li><li><p><span>Receive the original copies of your certificate and transcript on the next working day</span></p></li><li><p><span>Easily learn the skills and knowledge from the comfort of your home</span></p></li></ul><p><b><br /></b></p><h3><span>Certification</span></h3><p><span>After studying the course materials of the </span><span>Visual Basic and VBScript Training</span><span> 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.</span></p><p><b><br /></b></p><h3><span>Who is this course for?</span></h3><p><span>This </span><span>Visual Basic and VBScript Training</span><span> does not require you to have any prior qualifications or experience. You can just enrol and start learning. </span></p><ul><li><p><span>Aspiring software developers looking to learn Visual Basic and VBScript.</span></p></li><li><p><span>Programmers seeking to expand their knowledge of application development.</span></p></li><li><p><span>Web developers interested in using VBScript for dynamic web content.</span></p></li><li><p><span>IT professionals looking to enhance their scripting and programming skills.</span></p></li></ul><p><b><br /></b></p><h3><span>Prerequisites</span></h3><p><span>This </span><span>Visual Basic and VBScript Training </span><span>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.</span></p><p><b><br /></b></p><h3><span>Career path</span></h3><p></p><ul><li><p><span>Software Developer - Median salary of $110,000 - $120,000 per year.</span></p></li><li><p><span>Web Developer - Median salary of $75,000 - $85,000 per year.</span></p></li><li><p><span>Application Developer - Median salary of $90,000 - $100,000 per year.</span></p></li><li><p><span>Systems Analyst - Median salary of $80,000 - $90,000 per year.</span></p></li><li><p><span>IT Consultant - Median salary of $90,000 - $100,000 per year.</span></p></li></ul>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
									</div>
			</div>
					</div><div>
				<h3>
	<span>Course Curriculum</span>
</h3>

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4"> Section 01: Introduction</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction To This Course</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Setup On Windows</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Run Code Online</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 02: Basics</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Console Output</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Comments</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Variables</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Console Input</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Data Types</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Constants</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Enumerations</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Directives</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Operators</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>If Statement</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Switch Statement</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Loops</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Strings</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Date &amp; Time</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Arrays</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>For Each Loop</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>ArrayList</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Hashtable</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SortedList</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Stack</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Queue</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Subs</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Functions</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Exception Handling</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 03: Classes</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Simple Class Example</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Constructor</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Destructor</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Shared Properties</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Inheritance</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Scope</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 04: File Handling</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>File Handling</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 05: GUI</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Setup A GUI Project</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Forms</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>TextBox</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Label</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Button</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>ListBox</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>ComboBox</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>RadioButton</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>CheckBox</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>DateTimePicker</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>PictureBox</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>ProgressBar</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>GroupBox</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>TreeView</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>ListView</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Events</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 06: Dialog Box</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Color Dialog</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Font Dialog</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Open File Dialog</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Save File Dialog</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Print Dialog</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 08: Resource</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Menus</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Anchoring &amp; Docking</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Modals</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Regular Expressions</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Parsing an XML File</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 07: Advanced</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Resource - Visual Basic and VBScript Training</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Assignment</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Assignment - Visual Basic and VBScript Training</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table></div>

			</div>

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

Studyhub UK

Online Course Creation

Programming Fundamentals

Visual Basic and VBScript Training

<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div>
			<div></div>
		</div>
				</div>
				</div>
				<div>
				<div>
			
				</div>
				<div>
				<div>
					<div><p>Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step training course. This Excel VBA/Macros Foundations has been specially designed to help learners gain a good command of Excel VBA/Macros Foundations, providing them with a solid foundation of knowledge to become a qualified professional.</p><p>Through this Excel VBA/Macros Foundations, you will gain both practical and theoretical understanding of Excel VBA/Macros Foundations that will increase your employability in this field, help you stand out from the competition and boost your earning potential in no time.</p><p>Not only that, but this training includes up-to-date knowledge and techniques that will ensure you have the most in-demand skills to rise to the top of the industry. This qualification is fully accredited, broken down into several manageable modules, ideal for aspiring professionals.</p></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</div></section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2><b> Learning outcome</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Familiar yourself with the recent development and updates of the relevant industry</span>
									</li>
								<li>
											<span>
													</span>
										<span>Know how to use your theoretical knowledge to adapt in any working environment</span>
									</li>
								<li>
											<span>
													</span>
										<span>Get help from our expert tutors anytime you need</span>
									</li>
								<li>
											<span>
													</span>
										<span>Access to course contents that are designed and prepared by industry professionals</span>
									</li>
								<li>
											<span>
													</span>
										<span>Study at your convenient time and from wherever you want</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					</div>
				</div>
				<div>
				<div>
					<div>
							
					
									
							
					
									
							
					
									
							
					
									
					</div>
			</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> <b>Why should I take this course?</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Affordable premium-quality E-learning content, you can learn at your own pace.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will receive a completion certificate upon completing the course.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Internationally recognized Accredited Qualification will boost up your resume.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will learn the researched and proven approach adopted by successful people to transform their careers.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will be able to incorporate various techniques successfully and understand your customers better.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> <b>Requirements</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>No formal qualifications required, anyone from any academic background can take this course.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Access to a computer or digital device with internet connectivity.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step training course. This Excel VBA/Macros Foundations has been specially designed to help learners gain a good command of Excel VBA/Macros Foundations, providing them with a solid foundation of knowledge to become a qualified professional.
Through this Excel VBA/Macros Foundations, you will gain both practical and theoretical understanding of Excel VBA/Macros Foundations that will increase your employability in this field, help you stand out from the competition and boost your earning potential in no time.
Not only that, but this training includes up-to-date knowledge and techniques that will ensure you have the most in-demand skills to rise to the top of the industry. This qualification is fully accredited, broken down into several manageable modules, ideal for aspiring professionals.
 Learning outcome
Familiar yourself with the recent development and updates of the relevant industry
Know how to use your theoretical knowledge to adapt in any working environment
Get help from our expert tutors anytime you need
Access to course contents that are designed and prepared by industry professionals
Study at your convenient time and from wherever you want
 Why should I take this course?
Affordable premium-quality E-learning content, you can learn at your own pace.
You will receive a completion certificate upon completing the course.
Internationally recognized Accredited Qualification will boost up your resume.
You will learn the researched and proven approach adopted by successful people to transform their careers.
You will be able to incorporate various techniques successfully and understand your customers better.
 Requirements
No formal qualifications required, anyone from any academic background can take this course.
Access to a computer or digital device with internet connectivity.

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

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">One of our most popular courses, this Visual Merchandising Training Course is organised into 08 modules and includes everything you need to become successful in this industry.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">A visual merchandiser plays a critical role in the look, feel and culture of a brand. If visual merchandising is done well, it can create awareness whilst simultaneously increasing brand loyalty. If this sounds interesting to you, what are you waiting for?</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Beginning with the basics of design and colour, you will quickly gain new skills in prop construction, styling and the use of colour, texture, lighting, space, photography scent, touch and sound in your displays. On top of this, you will also be taught about working on real projects and how you can develop and implement your concepts. Covering all aspects of displays, creating visual communication tools and styling, this course can be completed part-time or in one, six-hour burst, making it ideal for all types of students.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;">Why choose the Visual Merchandising Course</span></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Earn an e-certificate upon successful completion.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Accessible, informative modules taught by expert instructors</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Study in your own time, at your own pace, through your computer tablet or mobile device</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Benefit from instant feedback through mock exams and multiple-choice assessments</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Get 24/7 help or advice from our email and live chat teams</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Full Tutor Support on Weekdays</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;">Course Design</span></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">You are taught through a combination of</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Video Lessons</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Online study materials</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Mock exams</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Multiple-choice assessment</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;">Certificate of Achievement</span></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;">Endorsed Certificate of Achievement from the Quality Licence Scheme</span></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only &pound;99. Please note that overseas students may be charged an additional &pound;10 for postage.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;">CPD Certificate from Janets</span></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of &pound;9.99 and PDF Certificate at &pound;4.99.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;">Endorsement</span></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example, progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;">Method of Assessment</span></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for a Quality Licence Scheme-endorsed certificate of achievement.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for you and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;">Who is this course for?</span></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Visual Merchandising Training Course is suitable for anyone who wants to gain extensive knowledge, potential experience and expert skills in the related field. This course is designed by industry experts so you don&rsquo;t have to worry about the quality.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Most importantly, this visual merchandising Course does not require any experience or lesson to get enrolled. You will learn everything that is required from this course directly. This is a great opportunity for all students from any academic background to learn more about this subject.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;">Course Contents</span></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Module 01: Introduction to Visual Merchandising</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Module 02: Store Layouts</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Module 03: Exterior Design</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Module 04: In-store Design</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Module 05: Mannequins in Visual Merchandising</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Module 06: Display Fixtures</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Module 07: The Role of a Visual Merchandiser</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Module 08: Challenges of Modern Visual Merchandising</li></ul>

One of our most popular courses, this Visual Merchandising Training Course is organised into 08 modules and includes everything you need to become successful in this industry.
A visual merchandiser plays a critical role in the look, feel and culture of a brand. If visual merchandising is done well, it can create awareness whilst simultaneously increasing brand loyalty. If this sounds interesting to you, what are you waiting for?
Beginning with the basics of design and colour, you will quickly gain new skills in prop construction, styling and the use of colour, texture, lighting, space, photography scent, touch and sound in your displays. On top of this, you will also be taught about working on real projects and how you can develop and implement your concepts. Covering all aspects of displays, creating visual communication tools and styling, this course can be completed part-time or in one, six-hour burst, making it ideal for all types of students. 
Why choose the Visual Merchandising Course
Earn an e-certificate upon successful completion.
Accessible, informative modules taught by expert instructors
Study in your own time, at your own pace, through your computer tablet or mobile device
Benefit from instant feedback through mock exams and multiple-choice assessments
Get 24/7 help or advice from our email and live chat teams
Full Tutor Support on Weekdays
Course Design
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
Video Lessons
Online study materials
Mock exams
Multiple-choice assessment
Certificate of Achievement
Endorsed Certificate of Achievement from the Quality Licence Scheme
Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99. Please note that overseas students may be charged an additional £10 for postage.
CPD Certificate from Janets
Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99.
Endorsement
This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example, progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website.
Method of Assessment
To complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for a Quality Licence Scheme-endorsed certificate of achievement.
To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for you and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support.
Who is this course for?
Visual Merchandising Training Course is suitable for anyone who wants to gain extensive knowledge, potential experience and expert skills in the related field. This course is designed by industry experts so you don’t have to worry about the quality.
Most importantly, this visual merchandising Course does not require any experience or lesson to get enrolled. You will learn everything that is required from this course directly. This is a great opportunity for all students from any academic background to learn more about this subject.
Course Contents
Module 01: Introduction to Visual Merchandising
Module 02: Store Layouts
Module 03: Exterior Design
Module 04: In-store Design
Module 05: Mannequins in Visual Merchandising
Module 06: Display Fixtures
Module 07: The Role of a Visual Merchandiser
Module 08: Challenges of Modern Visual Merchandising

Janets

Visual Merchandising

Visual Effects

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

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>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.</p>Overview<p>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</p><p>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</p>Prerequisites<p>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</p></div><div id="course-pills-2"><h3>1 - Using VBA to Solve Business Problems</h3> <ul> <li>Topic A: Use Macros to Automate Tasks in Excel</li> <li>Topic B: Identify Components of Macro-Enabled Workbooks</li> <li>Topic C: Configure the Excel VBA Environment</li> </ul> <h3>2 - Automating Repetitive Tasks</h3> <ul> <li>Topic A: Use the Macro Recorder to Create a VBA Macro</li> <li>Topic B: Record a Macro with Relative Addressing</li> <li>Topic C: Delete Macros and Modules</li> <li>Topic D: Identify Strategies for Using the Macro Recorder</li> </ul> <h3>3 - Getting Help on VBA</h3> <ul> <li>Topic A: Use VBA Help</li> <li>Topic B: Use the Object Browser to Discover Objects You Can Use in VBA</li> <li>Topic C: Use the Immediate Window to Explore Object Properties and Methods</li> </ul> <h3>4 - Creating Custom Worksheet Functions</h3> <ul> <li>Topic A: Create a Custom Function</li> <li>Topic B: Make Decisions in Code</li> <li>Topic C: Work with Variables</li> <li>Topic D: Perform Repetitive Tasks</li> </ul> <h3>5 - Improving Your VBA Code</h3> <ul> <li>Topic A: Debug VBA Errors</li> <li>Topic B: Deal with Errors</li> <li>Topic C: Improve Macro Performance</li> </ul> <h3>6 - Controlling How and When Macros Run</h3> <ul> <li>Topic A: Prompt the User for Information</li> <li>Topic B: Configure Macros to Run Automatically</li> </ul> <h3>7 - Developing Custom Forms</h3> <ul> <li>Topic A: Display a Custom Dialog Box</li> <li>Topic B: Program Form Events</li> </ul> <h3>8 - Using VBA to Work with Files</h3> <ul> <li>Topic A: Use VBA to Get File and Directory Structure</li> <li>Topic B: Use VBA to Read Text Files</li> <li>Topic C: Use VBA to Write Text Files</li> </ul> <h3>9 - Using VBA to Clean and Transform Data</h3> <ul> <li>Topic A: Automate Power Query</li> <li>Topic B: Transform Data Using VBA and Workbook Functions</li> <li>Topic C: Use Regular Expressions</li> <li>Topic D: Manage Errors in Data</li> </ul> <h3>10 - Extending the Programming Environment Beyond the Workbook</h3> <ul> <li>Topic A: Run Other Programs and Commands</li> <li>Topic B: Share Your VBA Projects</li> </ul></div>

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

Nexus Human

Office Skills & Productivity

Access VBA

Computer Skills

Microsoft Excel

Programming and Data Wrangling with VBA and Excel

London

<p><strong>Course Objectives</strong></p><p>At the end of this course you will be able to:</p><ul><li>Record and edit a Macro</li><li>Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects.</li><li>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</li><li>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</li><li>Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks</li><li>Create an error handling routine in case things go wrong with VBA code</li></ul><p>' 1 year email support service</p><p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p><em><strong>Customer Feedback</strong></em></p><ul><li><strong>Best Training Ever!</strong></li><li>Just finished a bespoke 1-1 training course in Excel Advanced, Macros &amp; 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.</li></ul><ul><li>Amanda Morris - Treasury &amp; Systems Accountant at Reall - Real Equity for All</li></ul><ul><li><p><strong>The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience..</strong></p></li><li>Simon Harper - Lloyd's of London</li></ul><ul><li><p><strong>My learning experience was awesome.</strong></p></li><li>Perdinand Reagan - Subsea7</li></ul><ul><li><p><strong>Very nice and relaxed approach to teaching. Was definitely a good learning experience</strong><strong>.</strong></p></li><li>Jerome Pupe - S5 Agency World</li></ul><ul><li><strong>The Trainer – Very positive + patient + helpful + thorough</strong></li><li>Agnes Souza - Direct Wines</li></ul><p>'</p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p><ul><li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul><p><strong><strong>Tailored training courses:</strong></strong></p><p>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.</p><p><strong>Introduction to Macros and VBA</strong></p><ul><li>Introducing Visual Basic for Applications</li><li>Recording a Macro</li><li>Naming conventions for Macro Procedures</li><li>Running a Macro</li><li>Absolute or Relative Cell Referencing</li><li>Saving and Opening Files with Macros</li><li>Making macros always available</li><li>Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes</li><li>Editing a Macro in the Visual Basic Editor</li><li>Understanding the Development Environment</li><li>Customising the Editor</li><li>Tips for General Typing in VBA</li><li>Using Visual Basic Help</li></ul><p><strong>Working with Procedures</strong></p><ul><li>Program Design</li><li>Understanding Modules</li><li>Naming Rules</li><li>Creating a Module</li><li>Understanding Procedures</li><li>Programming Macro Concepts</li><li>Creating a Subroutine</li><li>Creating a Function</li><li>Understanding Arguments</li><li>Exiting Procedures</li><li>Calling Procedures</li></ul><p><strong>Objects, Properties, Methods and Events</strong></p><ul><li>Understanding Objects Properties, Methods, and Events</li><li>Navigating the Object Hierarchy</li><li>Understanding Collections</li><li>Accessing a Member of a Collection</li><li>Understanding Hierarchy</li><li>Using the Object Browser</li><li>Using the With Statement</li><li>Working with Properties</li><li>Working with Methods</li><li>Creating an Event Procedure</li><li>Reserved Macro Names</li></ul><p><strong>Using Expressions, Variables and Intrinsic Functions</strong></p><ul><li>Understanding Expressions and Statements</li><li>Declaring Variables</li><li>Understanding Data Types</li><li>Determining the Value of Variables</li><li>Working with Variable Scope</li><li>Using Built-in VBA Functions</li><li>Understanding Constants</li><li>Using Message Boxes</li><li>Controlling the Answer to a Message Box</li><li>Using Input Boxes</li><li>Declaring and Using Object Variables</li></ul><p><strong>Controlling Program Execution</strong></p><ul><li>Understanding Control-of-Flow Structures</li><li>Using the If...End If Decision Structures</li><li>Nested If Statements</li><li>Using the Select Case ... End Select Structure</li><li>Using the Do ... Loop Structure</li><li>Using the For ... Next Structure</li><li>Using the For Each ... Next Structure</li><li>Guidelines for Use of Control-of-Flow Structures</li></ul><p><strong>Debugging and Handling Errors</strong></p><ul><li>Understanding Errors</li><li>Using Debugging Tools</li><li>Setting Breakpoints and Using Break Mode</li><li>Stepping Through Code</li><li>Trapping Errors with the On Error Statement</li><li>Understanding the Err Object</li><li>Working with Inline Error Handling</li><li>Writing an Error-Handling Routine</li></ul><p><strong>Working with Forms and Controls</strong></p><ul><li>Understanding UserForms</li><li>Creating a Form</li><li>Displaying and Removing a Form</li><li>Aligning and Sizing Controls</li><li>Using the Toolbox</li><li>Working with a Form's Properties, Methods, and Events</li><li>Working with Form and Control Properties, Methods and Event</li><li>Setting the Tab Order</li><li>Populating a Control</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>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.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Preferably, delegates should have attended the Excel Advanced course.</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

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 Office Training

Microsoft Office

Microsoft Excel Macros & VBA - In-company

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>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.</p>Overview<p>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.</p><p>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.</p>Prerequisites<p>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.</p></div><div id="course-pills-2"><h3>1. Using VBA to Solve Business Problems</h3><ul> <li>Use Macros to Automate Tasks in Excel</li> <li>Identify Components of Macro-Enabled Workbooks</li> <li>Configure the Excel VBA Environment</li></ul>  <h3>2. Recording a Macro</h3><ul> <li>Use the Macro Recorder to Create a VBA Macro</li> <li>Record a Macro with Relative Addressing</li> <li>Delete Macros and Modules</li> <li>Identify Strategies for Using the Macro Recorder</li></ul>  <h3>3. Writing VBA Code Directly</h3><ul> <li>Write VBA Code</li> <li>Discover Objects You Can Use</li> <li>Create a Custom Function</li></ul>  <h3>4. Solving Problems through Code</h3><ul> <li>Make Decisions in Code</li> <li>Work with Variables</li> <li>Perform Repetitive Tasks</li></ul>  <h3>5. Improving Your VBA Code</h3><ul> <li>Debug VBA Errors</li> <li>Deal with Errors</li> <li>Improve Macro Performance</li></ul>  <h3>6.  Controlling How and When Macros Run</h3><ul> <li>Prompt the User for Information</li> <li>Configure Macros to Run Automatically</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>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. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>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.  <p></p>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.<p></p></div>

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

<p><strong>Course Objectives</strong></p><p>At the end of this course you will be able to:</p><ul><li>Record and edit a Macro</li><li>Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects.</li><li>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</li><li>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</li><li>Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks</li><li>Create an error handling routine in case things go wrong with VBA code</li></ul><p>' 1 year email support service</p><p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p><em><strong>Customer Feedback</strong></em></p><ul><li><strong>Best Training Ever!</strong></li><li>Just finished a bespoke 1-1 training course in Excel Advanced, Macros &amp; 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.</li></ul><ul><li>Amanda Morris - Treasury &amp; Systems Accountant at Reall - Real Equity for All</li></ul><ul><li><p><strong>The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience..</strong></p></li><li>Simon Harper - Lloyd's of London</li></ul><ul><li><p><strong>My learning experience was awesome.</strong></p></li><li>Perdinand Reagan - Subsea7</li></ul><ul><li><p><strong>Very nice and relaxed approach to teaching. Was definitely a good learning experience</strong><strong>.</strong></p></li><li>Jerome Pupe - S5 Agency World</li></ul><ul><li><strong>The Trainer – Very positive + patient + helpful + thorough</strong></li><li>Agnes Souza - Direct Wines</li></ul><p>'</p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> classroom, one to one, tailored and bespoke courses.</strong></p><p><strong><strong>Tailored In Company training:</strong></strong></p><p>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.</p><p><strong>Introduction to Macros and VBA</strong></p><ul><li>Introducing Visual Basic for Applications</li><li>Recording a Macro</li><li>Naming conventions for Macro Procedures</li><li>Running a Macro</li><li>Absolute or Relative Cell Referencing</li><li>Saving and Opening Files with Macros</li><li>Making macros always available</li><li>Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes</li><li>Editing a Macro in the Visual Basic Editor</li><li>Understanding the Development Environment</li><li>Customising the Editor</li><li>Tips for General Typing in VBA</li><li>Using Visual Basic Help</li></ul><p><strong>Working with Procedures</strong></p><ul><li>Program Design</li><li>Understanding Modules</li><li>Naming Rules</li><li>Creating a Module</li><li>Understanding Procedures</li><li>Programming Macro Concepts</li><li>Creating a Subroutine</li><li>Creating a Function</li><li>Understanding Arguments</li><li>Exiting Procedures</li><li>Calling Procedures</li></ul><p><strong>Objects, Properties, Methods and Events</strong></p><ul><li>Understanding Objects Properties, Methods, and Events</li><li>Navigating the Object Hierarchy</li><li>Understanding Collections</li><li>Accessing a Member of a Collection</li><li>Understanding Hierarchy</li><li>Using the Object Browser</li><li>Using the With Statement</li><li>Working with Properties</li><li>Working with Methods</li><li>Creating an Event Procedure</li><li>Reserved Macro Names</li></ul><p><strong>Using Expressions, Variables and Intrinsic Functions</strong></p><ul><li>Understanding Expressions and Statements</li><li>Declaring Variables</li><li>Understanding Data Types</li><li>Determining the Value of Variables</li><li>Working with Variable Scope</li><li>Using Built-in VBA Functions</li><li>Understanding Constants</li><li>Using Message Boxes</li><li>Controlling the Answer to a Message Box</li><li>Using Input Boxes</li><li>Declaring and Using Object Variables</li></ul><p><strong>Controlling Program Execution</strong></p><ul><li>Understanding Control-of-Flow Structures</li><li>Using the If...End If Decision Structures</li><li>Nested If Statements</li><li>Using the Select Case ... End Select Structure</li><li>Using the Do ... Loop Structure</li><li>Using the For ... Next Structure</li><li>Using the For Each ... Next Structure</li><li>Guidelines for Use of Control-of-Flow Structures</li></ul><p><strong>Debugging and Handling Errors</strong></p><ul><li>Understanding Errors</li><li>Using Debugging Tools</li><li>Setting Breakpoints and Using Break Mode</li><li>Stepping Through Code</li><li>Trapping Errors with the On Error Statement</li><li>Understanding the Err Object</li><li>Working with Inline Error Handling</li><li>Writing an Error-Handling Routine</li></ul><p><strong>Working with Forms and Controls</strong></p><ul><li>Understanding UserForms</li><li>Creating a Form</li><li>Displaying and Removing a Form</li><li>Aligning and Sizing Controls</li><li>Using the Toolbox</li><li>Working with a Form's Properties, Methods, and Events</li><li>Working with Form and Control Properties, Methods and Event</li><li>Setting the Tab Order</li><li>Populating a Control</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>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.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Preferably, delegates should have attended the Excel Advanced course.</p>
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Excel know-how can instantly increase your job prospects as well as your salary.</p><p>80 percent of job openings require spreadsheet and word-processing software skills</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

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

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

AutoCAD

Hands on Programming on AutoCAD to Excel Using VB.NET

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

Educators providing Visual Basic Analysis courses in London delivered Online