{"id":640,"date":"2020-02-11T11:01:54","date_gmt":"2020-02-11T03:01:54","guid":{"rendered":"http:\/\/ensy.ioweb.studio\/?page_id=640"},"modified":"2020-03-16T11:07:14","modified_gmt":"2020-03-16T03:07:14","slug":"vba-for-microsoft-excel","status":"publish","type":"page","link":"https:\/\/ensy.my\/index.php\/public-training\/vba-for-microsoft-excel\/","title":{"rendered":"VBA for Microsoft Excel"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; fullwidth=&#8221;on&#8221; admin_label=&#8221;Hero Section&#8221; _builder_version=&#8221;3.11.1&#8243; background_image=&#8221;https:\/\/ensy.my\/wp-content\/uploads\/2019\/12\/job_recruitement_14.jpg&#8221; parallax=&#8221;on&#8221; custom_padding=&#8221;|||&#8221;][et_pb_fullwidth_header subhead=&#8221;VBA for Microsoft Excel&#8221; content_max_width=&#8221;900px&#8221; _builder_version=&#8221;3.11.1&#8243; title_font=&#8221;Poppins|600||on|||||&#8221; title_font_size=&#8221;18px&#8221; title_letter_spacing=&#8221;4px&#8221; title_line_height=&#8221;1.8em&#8221; content_font_size_last_edited=&#8221;off|desktop&#8221; subhead_font=&#8221;|700|||||||&#8221; subhead_font_size=&#8221;50px&#8221; subhead_font_size_tablet=&#8221;40px&#8221; subhead_font_size_phone=&#8221;30px&#8221; subhead_font_size_last_edited=&#8221;on|desktop&#8221; subhead_line_height=&#8221;1.1em&#8221; background_color=&#8221;rgba(126,190,197,0)&#8221; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_start=&#8221;rgba(255,255,255,0.76)&#8221; background_color_gradient_end=&#8221;#ffffff&#8221; background_color_gradient_direction=&#8221;1deg&#8221; background_color_gradient_start_position=&#8221;100%&#8221; background_color_gradient_end_position=&#8221;4%&#8221; background_color_gradient_overlays_image=&#8221;on&#8221; custom_button_two=&#8221;on&#8221; button_two_text_size=&#8221;14px&#8221; button_two_text_color=&#8221;#29cb8b&#8221; button_two_bg_color=&#8221;#ffffff&#8221; button_two_border_width=&#8221;12px&#8221; button_two_border_color=&#8221;#ffffff&#8221; button_two_letter_spacing=&#8221;2px&#8221; button_two_font=&#8221;Poppins|600||on|||||&#8221; button_two_icon=&#8221;%%3%%&#8221; button_two_letter_spacing_hover=&#8221;2px&#8221; custom_button_one=&#8221;on&#8221; button_one_text_size=&#8221;14px&#8221; button_one_bg_color=&#8221;#29cb8b&#8221; button_one_border_width=&#8221;12px&#8221; button_one_border_color=&#8221;#29cb8b&#8221; button_one_letter_spacing=&#8221;2px&#8221; button_one_font=&#8221;Poppins|600||on|||||&#8221; button_one_icon=&#8221;%%3%%&#8221; button_one_letter_spacing_hover=&#8221;2px&#8221; custom_padding=&#8221;25px||25px||true&#8221; background_layout=&#8221;light&#8221; subhead_text_color=&#8221;#000000&#8243;][\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;3.11.1&#8243;][et_pb_row _builder_version=&#8221;3.0.48&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.0.47&#8243; parallax=&#8221;off&#8221; parallax_method=&#8221;on&#8221;][et_pb_image src=&#8221;\/wp-content\/uploads\/2020\/01\/Slide102.png&#8221; show_in_lightbox=&#8221;on&#8221; align=&#8221;center&#8221; _builder_version=&#8221;3.11.1&#8243; animation_style=&#8221;fade&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;3.11.1&#8243; header_5_font_size=&#8221;20px&#8221; header_5_line_height=&#8221;1.3em&#8221; max_width=&#8221;80%&#8221; module_alignment=&#8221;center&#8221;]<\/p>\n<h5 style=\"text-align: center;\">This course will teach programming concepts and how to add functionality to a Microsoft Excel using Microsoft Visual Basic\u00ae for Applications.<\/h5>\n<p>[\/et_pb_text][et_pb_code _builder_version=&#8221;3.11.1&#8243;]Invalid slider ID or alias.[\/et_pb_code][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;3.0.48&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;3.0.47&#8243; parallax=&#8221;off&#8221; parallax_method=&#8221;on&#8221;][et_pb_text _builder_version=&#8221;3.11.1&#8243; custom_padding=&#8221;20px|20px|20px|20px&#8221; animation_style=&#8221;fade&#8221; custom_css_main_element=&#8221;background:#f0f8ff;&#8221;]<\/p>\n<h5><strong>At Course Completion<\/strong><\/h5>\n<p> At the end of the course, participants will be able to:<\/p>\n<ul>\n<li>Use the programming capabilities of Microsoft Visual Basic for Applications in Microsoft Excel applications to write custom functions and event-driven procedures.<\/li>\n<li>Validate data<\/li>\n<li>Find and trap errors<\/li>\n<li>Create a custom function for a Microsoft Excel application.<\/li>\n<\/ul>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;3.0.47&#8243; parallax=&#8221;off&#8221; parallax_method=&#8221;on&#8221;][et_pb_text _builder_version=&#8221;3.11.1&#8243; custom_padding=&#8221;20px|20px|98px|20px&#8221; custom_padding_phone=&#8221;||20px|&#8221; custom_padding_last_edited=&#8221;on|phone&#8221; animation_style=&#8221;fade&#8221; background_color=&#8221;#DFEFFF&#8221;]<\/p>\n<h5><strong>Prerequisites<\/strong><\/h5>\n<p> Before beginning this course, participants should be able to:<\/p>\n<ul>\n<li>Extensive understanding of Microsoft Excel or previous version of Microsoft Excel<\/li>\n<li>Basic programming knowledge in Visual Basic<\/li>\n<\/ul>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;3.11.1&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.0.47&#8243; parallax=&#8221;off&#8221; parallax_method=&#8221;on&#8221;][et_pb_text _builder_version=&#8221;3.11.1&#8243; text_font=&#8221;Nunito Sans||||||||&#8221; text_text_color=&#8221;#959baf&#8221; text_font_size=&#8221;18px&#8221; text_line_height=&#8221;1.8em&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#535b7c&#8221; header_font_size=&#8221;45px&#8221; header_line_height=&#8221;1.4em&#8221; header_2_font=&#8221;|700|||||||&#8221; header_2_text_color=&#8221;#535b7c&#8221; header_2_font_size=&#8221;35px&#8221; header_2_line_height=&#8221;1.3em&#8221; text_orientation=&#8221;center&#8221; max_width=&#8221;700px&#8221; module_alignment=&#8221;center&#8221; header_font=&#8221;||||||||&#8221;]<\/p>\n<h2>Why you should train with us?<\/h2>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row admin_label=&#8221;Images Row&#8221; _builder_version=&#8221;3.0.83&#8243;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.0.47&#8243; parallax=&#8221;off&#8221; parallax_method=&#8221;on&#8221;][et_pb_blurb title=&#8221;Quality Assured&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/medal.png&#8221; _builder_version=&#8221;3.11.1&#8243; header_text_align=&#8221;center&#8221; text_orientation=&#8221;center&#8221; animation_style=&#8221;slide&#8221; animation_direction=&#8221;bottom&#8221; animation_intensity_slide=&#8221;10%&#8221;][\/et_pb_blurb][et_pb_blurb title=&#8221;Generate New Idea&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/idea-1.png&#8221; _builder_version=&#8221;3.11.1&#8243; header_text_align=&#8221;center&#8221; text_orientation=&#8221;center&#8221; animation_style=&#8221;slide&#8221; animation_direction=&#8221;bottom&#8221; animation_intensity_slide=&#8221;10%&#8221;][\/et_pb_blurb][et_pb_blurb title=&#8221;Telephone Support&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/call.png&#8221; _builder_version=&#8221;3.11.1&#8243; header_text_align=&#8221;center&#8221; text_orientation=&#8221;center&#8221; animation_style=&#8221;slide&#8221; animation_direction=&#8221;bottom&#8221; animation_intensity_slide=&#8221;10%&#8221;][\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.0.47&#8243; parallax=&#8221;off&#8221; parallax_method=&#8221;on&#8221;][et_pb_blurb title=&#8221;Certified Instructor&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/award.png&#8221; _builder_version=&#8221;3.11.1&#8243; header_text_align=&#8221;center&#8221; text_orientation=&#8221;center&#8221; animation_style=&#8221;slide&#8221; animation_direction=&#8221;bottom&#8221; animation_intensity_slide=&#8221;10%&#8221;][\/et_pb_blurb][et_pb_blurb title=&#8221;Improve Productivity&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/hand.png&#8221; _builder_version=&#8221;3.11.1&#8243; header_text_align=&#8221;center&#8221; text_orientation=&#8221;center&#8221; animation_style=&#8221;slide&#8221; animation_direction=&#8221;bottom&#8221; animation_intensity_slide=&#8221;10%&#8221;][\/et_pb_blurb][et_pb_blurb title=&#8221;SMS Support&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/sms.png&#8221; _builder_version=&#8221;3.11.1&#8243; header_text_align=&#8221;center&#8221; text_orientation=&#8221;center&#8221; animation_style=&#8221;slide&#8221; animation_direction=&#8221;bottom&#8221; animation_intensity_slide=&#8221;10%&#8221;][\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.0.47&#8243; parallax=&#8221;off&#8221; parallax_method=&#8221;on&#8221;][et_pb_blurb title=&#8221;Practical Example&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/pencil.png&#8221; _builder_version=&#8221;3.11.1&#8243; header_text_align=&#8221;center&#8221; text_orientation=&#8221;center&#8221; animation_style=&#8221;slide&#8221; animation_direction=&#8221;bottom&#8221; animation_intensity_slide=&#8221;10%&#8221;][\/et_pb_blurb][et_pb_blurb title=&#8221;Updated Resources&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/excel.png&#8221; _builder_version=&#8221;3.11.1&#8243; header_text_align=&#8221;center&#8221; text_orientation=&#8221;center&#8221; animation_style=&#8221;slide&#8221; animation_direction=&#8221;bottom&#8221; animation_intensity_slide=&#8221;10%&#8221;][\/et_pb_blurb][et_pb_blurb title=&#8221;Email Support&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/email.png&#8221; _builder_version=&#8221;3.11.1&#8243; header_text_align=&#8221;center&#8221; text_orientation=&#8221;center&#8221; animation_style=&#8221;slide&#8221; animation_direction=&#8221;bottom&#8221; animation_intensity_slide=&#8221;10%&#8221;][\/et_pb_blurb][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;3.0.87&#8243; background_color=&#8221;#f8fbfe&#8221; custom_padding=&#8221;54px|0px|3px|0px|false|false&#8221;][et_pb_row _builder_version=&#8221;3.0.83&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.0.47&#8243; parallax=&#8221;off&#8221; parallax_method=&#8221;on&#8221;][et_pb_text _builder_version=&#8221;3.11.1&#8243; text_font=&#8221;||||||||&#8221; text_text_color=&#8221;#959baf&#8221; text_font_size=&#8221;18px&#8221; text_line_height=&#8221;1.8em&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#535b7c&#8221; header_font_size=&#8221;45px&#8221; header_line_height=&#8221;1.4em&#8221; header_2_font=&#8221;|700|||||||&#8221; header_2_text_color=&#8221;#535b7c&#8221; header_2_font_size=&#8221;35px&#8221; header_2_line_height=&#8221;1.3em&#8221; text_orientation=&#8221;center&#8221; max_width=&#8221;700px&#8221; module_alignment=&#8221;center&#8221; header_font=&#8221;||||||||&#8221;]<\/p>\n<h2>Course Outline<\/h2>\n<p>Duration: 2 days<br \/>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row use_custom_gutter=&#8221;on&#8221; gutter_width=&#8221;2&#8243; custom_padding=&#8221;15px||15px|&#8221; use_background_color_gradient_1=&#8221;off&#8221; use_background_color_gradient_2=&#8221;off&#8221; use_background_color_gradient_3=&#8221;on&#8221; background_color_gradient_start_1=&#8221;#3D72E7&#8243; background_color_gradient_start_2=&#8221;#3D72E7&#8243; background_color_gradient_start_3=&#8221;#3D72E7&#8243; background_color_gradient_end_1=&#8221;#53a0fe&#8221; background_color_gradient_end_2=&#8221;#53a0fe&#8221; background_color_gradient_end_3=&#8221;#53A0FE&#8221; background_color_gradient_direction_1=&#8221;243deg&#8221; background_color_gradient_direction_2=&#8221;243deg&#8221; background_color_gradient_direction_3=&#8221;243deg&#8221; _builder_version=&#8221;3.0.87&#8243;][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;3.0.47&#8243; parallax=&#8221;off&#8221; parallax_method=&#8221;on&#8221; use_background_color_gradient=&#8221;off&#8221; background_color_gradient_start=&#8221;#3D72E7&#8243; background_color_gradient_end=&#8221;#53a0fe&#8221; background_color_gradient_direction=&#8221;243deg&#8221;][et_pb_blurb title=&#8221;Module 1: Make a Macro Do Simple Tasks&#8221; icon_placement=&#8221;left&#8221; content_max_width=&#8221;470px&#8221; admin_label=&#8221;Module 1&#8243; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|600|||||||&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#535b7c&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;||||||||&#8221; body_text_align=&#8221;left&#8221; body_text_color=&#8221;#959baf&#8221; body_font_size=&#8221;16px&#8221; background_color=&#8221;#ffffff&#8221; border_radii=&#8221;on|4px|4px|4px|4px&#8221; border_width_top=&#8221;6px&#8221; border_color_top=&#8221;#3D72E7&#8243; box_shadow_style=&#8221;preset3&#8243; box_shadow_color=&#8221;rgba(34,56,101,0.12)&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;||6%|&#8221; custom_padding=&#8221;40px|20px|40px|20px&#8221; animation_style=&#8221;zoom&#8221; animation_intensity_zoom=&#8221;10%&#8221;]<\/p>\n<ul>\n<li>What\u2019s the Difference between VBA and a Macro<\/li>\n<li>Creating a Simple Macro<\/li>\n<li>Changing Multiple Properties at Once<\/li>\n<li>Manipulating Recorded Properties<\/li>\n<li>Recording Methods in a Macro<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb title=&#8221;Module 2: Make a Macro Do Complex Tasks&#8221; icon_placement=&#8221;left&#8221; content_max_width=&#8221;470px&#8221; admin_label=&#8221;MODULE 3: Analysing Data&#8221; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|600|||||||&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#535b7c&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;||||||||&#8221; body_text_align=&#8221;left&#8221; body_text_color=&#8221;#959baf&#8221; body_font_size=&#8221;16px&#8221; background_color=&#8221;#ffffff&#8221; border_radii=&#8221;on|4px|4px|4px|4px&#8221; border_width_top=&#8221;6px&#8221; border_color_top=&#8221;#3D72E7&#8243; box_shadow_style=&#8221;preset3&#8243; box_shadow_color=&#8221;rgba(34,56,101,0.12)&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;||6%|&#8221; custom_padding=&#8221;40px|20px|40px|20px&#8221; animation_style=&#8221;zoom&#8221; animation_intensity_zoom=&#8221;10%&#8221;]<\/p>\n<ul>\n<li>Task One: Opening the Report file<\/li>\n<li>Task Two: Filling in Missing Labels<\/li>\n<li>Task Three: Adding a Column of Dates<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb title=&#8221;Module 3: Explore Workbooks and Worksheets&#8221; icon_placement=&#8221;left&#8221; content_max_width=&#8221;470px&#8221; admin_label=&#8221;5&#8243; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|600|||||||&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#535b7c&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;||||||||&#8221; body_text_align=&#8221;left&#8221; body_text_color=&#8221;#959baf&#8221; body_font_size=&#8221;16px&#8221; background_color=&#8221;#ffffff&#8221; border_radii=&#8221;on|4px|4px|4px|4px&#8221; border_width_top=&#8221;6px&#8221; border_color_top=&#8221;#3D72E7&#8243; box_shadow_style=&#8221;preset3&#8243; box_shadow_color=&#8221;rgba(34,56,101,0.12)&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;||6%|&#8221; custom_padding=&#8221;40px|20px|40px|20px&#8221; animation_style=&#8221;zoom&#8221; animation_intensity_zoom=&#8221;10%&#8221;]<\/p>\n<ul>\n<li>What is an object?<\/li>\n<li>Understanding Workbooks<\/li>\n<li>Understanding Worksheets<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb title=&#8221;Module 4: Explore Range Object&#8221; icon_placement=&#8221;left&#8221; content_max_width=&#8221;470px&#8221; admin_label=&#8221;5&#8243; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|600|||||||&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#535b7c&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;||||||||&#8221; body_text_align=&#8221;left&#8221; body_text_color=&#8221;#959baf&#8221; body_font_size=&#8221;16px&#8221; background_color=&#8221;#ffffff&#8221; border_radii=&#8221;on|4px|4px|4px|4px&#8221; border_width_top=&#8221;6px&#8221; border_color_top=&#8221;#3D72E7&#8243; box_shadow_style=&#8221;preset3&#8243; box_shadow_color=&#8221;rgba(34,56,101,0.12)&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;||6%|&#8221; custom_padding=&#8221;40px|20px|40px|20px&#8221; animation_style=&#8221;zoom&#8221; animation_intensity_zoom=&#8221;10%&#8221;]<\/p>\n<ul>\n<li>Referring to a Range<\/li>\n<li>Enhancing Recorded Selections<\/li>\n<li>Entering Values and Formulas into a Range<\/li>\n<li>Formatting a Range<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;3.0.47&#8243; parallax=&#8221;off&#8221; parallax_method=&#8221;on&#8221; use_background_color_gradient=&#8221;off&#8221; background_color_gradient_start=&#8221;#3D72E7&#8243; background_color_gradient_end=&#8221;#53a0fe&#8221; background_color_gradient_direction=&#8221;243deg&#8221;][et_pb_blurb title=&#8221;Module 5: Explore Data Objects&#8221; icon_placement=&#8221;left&#8221; content_max_width=&#8221;470px&#8221; admin_label=&#8221;5&#8243; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|600|||||||&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#535b7c&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;||||||||&#8221; body_text_align=&#8221;left&#8221; body_text_color=&#8221;#959baf&#8221; body_font_size=&#8221;16px&#8221; background_color=&#8221;#ffffff&#8221; border_radii=&#8221;on|4px|4px|4px|4px&#8221; border_width_top=&#8221;6px&#8221; border_color_top=&#8221;#3D72E7&#8243; box_shadow_style=&#8221;preset3&#8243; box_shadow_color=&#8221;rgba(34,56,101,0.12)&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;||6%|&#8221; custom_padding=&#8221;40px|20px|40px|20px&#8221; animation_style=&#8221;zoom&#8221; animation_intensity_zoom=&#8221;10%&#8221;]<\/p>\n<ul>\n<li>Working with Excel Tables<\/li>\n<li>Working with PivotTable Reports<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb title=&#8221;Module 6: Explore Graphical Objects&#8221; icon_placement=&#8221;left&#8221; content_max_width=&#8221;470px&#8221; admin_label=&#8221;module 2&#8243; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|600|||||||&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#535b7c&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;||||||||&#8221; body_text_align=&#8221;left&#8221; body_text_color=&#8221;#959baf&#8221; body_font_size=&#8221;16px&#8221; background_color=&#8221;#ffffff&#8221; border_radii=&#8221;on|4px|4px|4px|4px&#8221; border_width_top=&#8221;6px&#8221; border_color_top=&#8221;#3D72E7&#8243; box_shadow_style=&#8221;preset3&#8243; box_shadow_color=&#8221;rgba(34,56,101,0.12)&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;||6%|&#8221; custom_padding=&#8221;40px|20px|40px|20px&#8221; animation_style=&#8221;zoom&#8221; animation_intensity_zoom=&#8221;10%&#8221;]<\/p>\n<ul>\n<li>Exploring Graphical Objects<\/li>\n<li>Exploring Charts Objects<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb title=&#8221;Module 7: Control Visual Basic&#8221; icon_placement=&#8221;left&#8221; content_max_width=&#8221;470px&#8221; admin_label=&#8221;MODULE 4: Importing Data to Excel&#8221; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|600|||||||&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#535b7c&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;||||||||&#8221; body_text_align=&#8221;left&#8221; body_text_color=&#8221;#959baf&#8221; body_font_size=&#8221;16px&#8221; background_color=&#8221;#ffffff&#8221; border_radii=&#8221;on|4px|4px|4px|4px&#8221; border_color_all=&#8221;#1e1584&#8243; border_width_top=&#8221;6px&#8221; border_color_top=&#8221;#3D72E7&#8243; box_shadow_style=&#8221;preset3&#8243; box_shadow_color=&#8221;rgba(34,56,101,0.12)&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;||6%|&#8221; custom_padding=&#8221;40px|20px|40px|20px&#8221; animation_style=&#8221;zoom&#8221; animation_intensity_zoom=&#8221;10%&#8221;]<\/p>\n<ul>\n<li>Using Conditionals<\/li>\n<li>Creating Loops<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb title=&#8221;Module 8: Extend Excel and Visual Basic&#8221; icon_placement=&#8221;left&#8221; content_max_width=&#8221;470px&#8221; admin_label=&#8221;MODULE 4: Importing Data to Excel&#8221; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|600|||||||&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#535b7c&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;||||||||&#8221; body_text_align=&#8221;left&#8221; body_text_color=&#8221;#959baf&#8221; body_font_size=&#8221;16px&#8221; background_color=&#8221;#ffffff&#8221; border_radii=&#8221;on|4px|4px|4px|4px&#8221; border_color_all=&#8221;#1e1584&#8243; border_width_top=&#8221;6px&#8221; border_color_top=&#8221;#3D72E7&#8243; box_shadow_style=&#8221;preset3&#8243; box_shadow_color=&#8221;rgba(34,56,101,0.12)&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;||6%|&#8221; custom_padding=&#8221;40px|20px|40px|20px&#8221; animation_style=&#8221;zoom&#8221; animation_intensity_zoom=&#8221;10%&#8221;]<\/p>\n<ul>\n<li>Creating Custom Functions<\/li>\n<li>Handling Errors<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb title=&#8221;Module 9: Launch Macros with Events&#8221; icon_placement=&#8221;left&#8221; content_max_width=&#8221;470px&#8221; admin_label=&#8221;MODULE 4: Importing Data to Excel&#8221; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|600|||||||&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#535b7c&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;||||||||&#8221; body_text_align=&#8221;left&#8221; body_text_color=&#8221;#959baf&#8221; body_font_size=&#8221;16px&#8221; background_color=&#8221;#ffffff&#8221; border_radii=&#8221;on|4px|4px|4px|4px&#8221; border_color_all=&#8221;#1e1584&#8243; border_width_top=&#8221;6px&#8221; border_color_top=&#8221;#3D72E7&#8243; box_shadow_style=&#8221;preset3&#8243; box_shadow_color=&#8221;rgba(34,56,101,0.12)&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;||6%|&#8221; custom_padding=&#8221;40px|20px|40px|20px&#8221; animation_style=&#8221;zoom&#8221; animation_intensity_zoom=&#8221;10%&#8221;]<\/p>\n<ul>\n<li>Creating Custom Command Buttons<\/li>\n<li>Handling Worksheet and Workbook Events<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;Get Started CTA&#8221; _builder_version=&#8221;3.0.83&#8243; background_color=&#8221;#202332&#8243; box_shadow_style=&#8221;preset3&#8243; box_shadow_vertical=&#8221;160px&#8221; box_shadow_blur=&#8221;0px&#8221; box_shadow_spread=&#8221;-80px&#8221; box_shadow_color=&#8221;#ffffff&#8221; box_shadow_position=&#8221;inner&#8221; custom_padding=&#8221;0px|0px|100px|0px&#8221; saved_tabs=&#8221;all&#8221;][et_pb_row custom_padding=&#8221;32px|40px||40px&#8221; admin_label=&#8221;CTA Row&#8221; _builder_version=&#8221;3.0.93&#8243; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_start=&#8221;#3D72E7&#8243; background_color_gradient_end=&#8221;#53A0FE&#8221; background_color_gradient_direction=&#8221;243deg&#8221; border_radii=&#8221;on|4px|4px|4px|4px&#8221;][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;3.0.47&#8243; parallax=&#8221;off&#8221; parallax_method=&#8221;on&#8221;][et_pb_text _builder_version=&#8221;3.11.1&#8243; text_font=&#8221;Nunito Sans||||||||&#8221; text_text_color=&#8221;#ffffff&#8221; text_font_size=&#8221;15px&#8221; header_font=&#8221;|700|||||||&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#ffffff&#8221; header_font_size=&#8221;35px&#8221; header_line_height=&#8221;1.4em&#8221; header_2_font=&#8221;|700|||||||&#8221; header_2_text_align=&#8221;left&#8221; header_2_text_color=&#8221;#ffffff&#8221; header_2_font_size=&#8221;35px&#8221; header_2_line_height=&#8221;1.4em&#8221; custom_margin=&#8221;||| &#8220;]<\/p>\n<h2>Download PDF Version Here<\/h2>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.0.47&#8243; parallax=&#8221;off&#8221; parallax_method=&#8221;on&#8221;][et_pb_button button_url=&#8221;\/wp-content\/uploads\/2020\/02\/ENSY-VBA-for-Excel.pdf&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Download&#8221; button_alignment=&#8221;right&#8221; _builder_version=&#8221;3.11.1&#8243; custom_button=&#8221;on&#8221; button_text_size=&#8221;13px&#8221; button_text_color=&#8221;#3d72e7&#8243; button_bg_color=&#8221;#ffffff&#8221; button_bg_color_gradient_start=&#8221;#3D72E7&#8243; button_bg_color_gradient_end=&#8221;#53a0fe&#8221; button_bg_color_gradient_direction=&#8221;243deg&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;26px&#8221; button_letter_spacing=&#8221;1px&#8221; button_font=&#8221;|600||on|||||&#8221; button_use_icon=&#8221;off&#8221; button_text_color_hover=&#8221;#3d72e7&#8243; button_bg_color_hover=&#8221;#ffffff&#8221; button_border_radius_hover=&#8221;26px&#8221; button_letter_spacing_hover=&#8221;1px&#8221; custom_margin=&#8221;|||&#8221; custom_padding=&#8221;15px|30px|15px|30px&#8221;]&nbsp;<br \/>\n[\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;contact-section&#8221; _builder_version=&#8221;3.11.1&#8243; background_color=&#8221;#f1f5f9&#8243; animation_style=&#8221;slide&#8221; animation_duration=&#8221;1100ms&#8221; animation_speed_curve=&#8221;ease-in&#8221;][et_pb_row _builder_version=&#8221;3.0.48&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.0.47&#8243; parallax=&#8221;off&#8221; parallax_method=&#8221;on&#8221;][et_pb_text _builder_version=&#8221;3.11.1&#8243;]<\/p>\n<h3 style=\"text-align: center;\"><strong>Interested to know more about this course? Reach out to us now!<\/strong><\/h3>\n<p>[\/et_pb_text][et_pb_contact_form email=&#8221;training@ensy.my, maychung@ensy.my &#8221; custom_message=&#8221;Course: VBA for Microsoft Excel||et_pb_line_break_holder||||et_pb_line_break_holder||Name: %%Name%%||et_pb_line_break_holder||Email: %%Email%%||et_pb_line_break_holder||Mobile: %%Mobile%%||et_pb_line_break_holder||Message: %%Message%%||et_pb_line_break_holder||&#8221; module_id=&#8221;et_pb_contact_form_0&#8243; _builder_version=&#8221;3.11.1&#8243;][et_pb_contact_field field_id=&#8221;Name&#8221; field_title=&#8221;Name *&#8221; fullwidth_field=&#8221;on&#8221; _builder_version=&#8221;3.11.1&#8243;][\/et_pb_contact_field][et_pb_contact_field field_id=&#8221;Email&#8221; field_title=&#8221;Email *&#8221; field_type=&#8221;email&#8221; fullwidth_field=&#8221;on&#8221; _builder_version=&#8221;3.11.1&#8243;][\/et_pb_contact_field][et_pb_contact_field field_id=&#8221;Mobile&#8221; field_title=&#8221;Mobile *&#8221; fullwidth_field=&#8221;on&#8221; _builder_version=&#8221;3.11.1&#8243;][\/et_pb_contact_field][et_pb_contact_field field_id=&#8221;Message&#8221; field_title=&#8221;Message&#8221; field_type=&#8221;text&#8221; required_mark=&#8221;off&#8221; fullwidth_field=&#8221;on&#8221; _builder_version=&#8221;3.11.1&#8243;][\/et_pb_contact_field][\/et_pb_contact_form][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; fullwidth=&#8221;on&#8221; admin_label=&#8221;Hero Section&#8221; _builder_version=&#8221;3.11.1&#8243; background_image=&#8221;https:\/\/ensy.my\/wp-content\/uploads\/2019\/12\/job_recruitement_14.jpg&#8221; parallax=&#8221;on&#8221; custom_padding=&#8221;|||&#8221;][et_pb_fullwidth_header subhead=&#8221;VBA for Microsoft Excel&#8221; content_max_width=&#8221;900px&#8221; _builder_version=&#8221;3.11.1&#8243; title_font=&#8221;Poppins|600||on|||||&#8221; title_font_size=&#8221;18px&#8221; title_letter_spacing=&#8221;4px&#8221; title_line_height=&#8221;1.8em&#8221; content_font_size_last_edited=&#8221;off|desktop&#8221; subhead_font=&#8221;|700|||||||&#8221; subhead_font_size=&#8221;50px&#8221; subhead_font_size_tablet=&#8221;40px&#8221; subhead_font_size_phone=&#8221;30px&#8221; subhead_font_size_last_edited=&#8221;on|desktop&#8221; subhead_line_height=&#8221;1.1em&#8221; background_color=&#8221;rgba(126,190,197,0)&#8221; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_start=&#8221;rgba(255,255,255,0.76)&#8221; background_color_gradient_end=&#8221;#ffffff&#8221; background_color_gradient_direction=&#8221;1deg&#8221; background_color_gradient_start_position=&#8221;100%&#8221; background_color_gradient_end_position=&#8221;4%&#8221; background_color_gradient_overlays_image=&#8221;on&#8221; custom_button_two=&#8221;on&#8221; button_two_text_size=&#8221;14px&#8221; button_two_text_color=&#8221;#29cb8b&#8221; button_two_bg_color=&#8221;#ffffff&#8221; button_two_border_width=&#8221;12px&#8221; button_two_border_color=&#8221;#ffffff&#8221; button_two_letter_spacing=&#8221;2px&#8221; button_two_font=&#8221;Poppins|600||on|||||&#8221; button_two_icon=&#8221;%%3%%&#8221; button_two_letter_spacing_hover=&#8221;2px&#8221; custom_button_one=&#8221;on&#8221; button_one_text_size=&#8221;14px&#8221; button_one_bg_color=&#8221;#29cb8b&#8221; button_one_border_width=&#8221;12px&#8221; button_one_border_color=&#8221;#29cb8b&#8221; button_one_letter_spacing=&#8221;2px&#8221; button_one_font=&#8221;Poppins|600||on|||||&#8221; button_one_icon=&#8221;%%3%%&#8221; button_one_letter_spacing_hover=&#8221;2px&#8221; custom_padding=&#8221;25px||25px||true&#8221; background_layout=&#8221;light&#8221; [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":36,"menu_order":13,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/pages\/640"}],"collection":[{"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/comments?post=640"}],"version-history":[{"count":13,"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/pages\/640\/revisions"}],"predecessor-version":[{"id":1098,"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/pages\/640\/revisions\/1098"}],"up":[{"embeddable":true,"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/pages\/36"}],"wp:attachment":[{"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/media?parent=640"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}