17780 Courses

Following on from the Macros course look at how you can write your own Visual Basic code within Excel to fully automate tasks and save time. Course overview Duration: 2 days (13 hours) Our VBA in Excel course is an introduction to using the Visual Basic for Applications language for programming in Excel. It looks at structures, syntax and coding standards. This course is designed for existing experienced users of Excel who can record and run macros and those who have dabbled in VBA but would like some formal training and help to put some structure to their code. Objectives  By the end of the course you will be able to: Write visual basic procedures Create event and general procedures Use commands from the Excel data model Use statements and functions Use a selection of debugging tools Create and use variables and constants Use different types of loops Create an Excel user form Content The VBA environment Project explorer Excel objects Modules Properties window Code window Code structure Code structure Navigating within your code Adding comments Using WITH Steps to creating a VBA procedure Procedures Sub procedures Event procedures Calling procedures The Excel data model Workbook commands Worksheet commands Excel selection methods Data manipulation commands Debugging Using breakpoints Stepping through code The immediate window The watch window The locals window points Variables and Constants Declaring variables Declaring multiple variables Variable data types Concatenation Scope of variables Constants Declaring constants Using constants Scope of constants Looping Do while loops Do until loops For next loops Conditional Statements IF statement SELECT CASE statement Comparison statements Logical operators Creating a User Form Form layout The control toolbox Naming conventions Adding objects Naming objects Captions Displaying the form Object properties Object properties Setting properties at design time Setting properties at run time Interconnectivity between the user form and Excel Comparing values Transferring information Running code

Whether it's for fun, friendship, fitness, or for your future, dancing is a great way to express yourself and grow. If you're looking for something fun and free, or something more technical and focused there's a dance class here for you. We hope you will enjoy your time at our dance school! An exciting and fresh dance school in Aberdeen, Scotland.

Elevate your expertise in warehousing and storage with our comprehensive course for inventory managers. Explore fundamental principles, efficient warehouse design, streamlined operations, inventory control strategies, safety protocols, performance metrics, and emerging trends. Gain the knowledge to optimize your warehouse for success in the ever-evolving world of logistics and supply chain management.

The main topics to be covered in this course are about everyday activities, family, friends, life events, remembering and forgetting, characteristics of people, holidays and more; Students practise their speaking, writing, listening and reading skills in and out of class with their teachers and classmates using their books and applications; The course is based on Ελληνικά Α and Κλικ στα Ελληνικά. In addition, there is a wide range of language material designed by the Greek LOL Teachers. All lessons are supported by educational applications to help students enrich their vocabulary and practise their Greek with fun and interactive exercises, videos and games.

Maximise your potential with bespoke individual development

DC's The Flash Themed Activity Day at Newton Boys & Girls Club for children aged 7+ years old Come and join us for an exciting HAF Activity themed around The Flash, Batman and Super Girl, which includes graffiti art, parkour, obstacle courses and games with our talented team from Powered by Hip Hop (UC Crew) Children and teens age 7+ who are eligible for free HAF activities are all welcome to join us for our FREE funded activity day. (Younger sibling can attend if registered but not be able to do all activities)

Spiderman Themed Activity Day at Derbyshire Hill Family & Community Centre for children and teens aged 7+ Come and join us for an exciting HAF Activity themed around Spiderman which includes break dance, art, parkour, obstacle courses and games with our talented team from Powered by Hip Hop (UC Crew) Children aged 7+ and parents/carers/grandparents who are eligible for free HAF activities are all welcome to join us for our FREE funded activity day. Younger siblings can attend but may not be able to participate in some older age activities We have the best Hip Hop and action-packed superhero-themed activities in St Helens, so don't miss out!

Come and join us for an exciting HAF Activity themed around Spiderman, which includes art, parkour, obstacle courses, break dancing and games with our talented team from Powered by Hip Hop (UC Crew) Children and teens age 4-6+ who are eligible for free HAF activities are all welcome to join us for our FREE funded activity day. (Older sibling can attend if registered)

Barbie & Zombies Themed Activity Day at Newton Boys & Girls Club for children aged 4-6 years old Come and join us for an exciting HAF Activity themed around the Barbie movie and zombies, which includes art, musics and games with our talented team from Powered by Hip Hop (UC Crew) Children age 4-6+ who are eligible for free HAF activities are all welcome to join us for our FREE funded activity day. (Older sibling can attend if registered)

Transformers Themed Activity Day at Derbyshire Hill Family & Community Centre for children and teens aged 7+ Come and join us for an exciting HAF Activity themed around Transformers which includes graffiti art, djing, parkour, obstacle courses and games with our talented team from Powered by Hip Hop (UC Crew) Children aged 7+ and parents/carers/grandparents who are eligible for free HAF activities are all welcome to join us for our FREE funded activity day.