{"id":2072,"date":"2026-01-31T00:12:51","date_gmt":"2026-01-31T00:12:51","guid":{"rendered":"https:\/\/www.exceldepartment.com\/?page_id=2072"},"modified":"2026-10-31T12:34:58","modified_gmt":"2026-10-31T12:34:58","slug":"vba-reference-card-beginners","status":"publish","type":"page","link":"https:\/\/www.exceldepartment.com\/en\/vba-reference-card-beginners\/","title":{"rendered":"The VBA Reference Card \u2014 Cheat Sheet for Beginners"},"content":{"rendered":"<h1>The VBA Reference Card \u2014 Cheat Sheet for Beginners<\/h1>\n<p style=\"font-size: 20px;\">The most important VBA commands on 2 A4 pages. Print it and hang it by your screen when you code.<\/p>\n<h2>Contents<\/h2>\n<ul>\n<li>Basic syntax (Sub, Function, End)<\/li>\n<li>Variables and data types (String, Integer, Boolean\u2026)<\/li>\n<li>Range and Cells (cell references)<\/li>\n<li>Loops (For\u2026Next, Do\u2026While)<\/li>\n<li>If\u2026Then\u2026Else (conditions)<\/li>\n<li>Common methods (.Value, .Formula, .Copy, .Delete)<\/li>\n<li>Common objects (Workbook, Worksheet, Range)<\/li>\n<li>Debugging techniques<\/li>\n<li>Keyboard shortcuts in the VBA editor<\/li>\n<\/ul>\n<h2>Download the VBA reference card for free<\/h2>\n<p>Enter your e-mail and we will send you the PDF straight away.<\/p>\n<div class=\"fusion-form fusion-form-builder fusion-form-form-wrapper fusion-form-2378\" style=\"--awb-tooltip-text-color:#ffffff;--awb-tooltip-background-color:#333333;\" data-form-id=\"2378\" data-config=\"{&quot;form_id&quot;:2378,&quot;form_post_id&quot;:2378,&quot;post_id&quot;:2072,&quot;form_type&quot;:&quot;ajax&quot;,&quot;confirmation_type&quot;:[&quot;redirect&quot;],&quot;redirect_url&quot;:&quot;https:\\\/\\\/www.exceldepartment.com\\\/en\\\/thank-you-for-your-download-gantt\\\/&quot;,&quot;redirect_timeout&quot;:&quot;0&quot;,&quot;field_labels&quot;:{&quot;epost&quot;:&quot;Your email address&quot;,&quot;samtycke&quot;:&quot;Consent&quot;},&quot;field_logics&quot;:{&quot;epost&quot;:&quot;&quot;,&quot;samtycke&quot;:&quot;&quot;,&quot;submit_1&quot;:&quot;&quot;},&quot;field_types&quot;:{&quot;epost&quot;:&quot;email&quot;,&quot;samtycke&quot;:&quot;consent&quot;,&quot;submit_1&quot;:&quot;submit&quot;},&quot;nonce_method&quot;:&quot;ajax&quot;,&quot;form_views&quot;:&quot;&quot;,&quot;form_views_counting&quot;:&quot;&quot;}\"><form action=\"https:\/\/www.exceldepartment.com\/en\/vba-reference-card-beginners\/\" target=\"_self\" method=\"post\" class=\"fusion-form fusion-form-2378\"><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-padding-top:0px;--awb-padding-bottom:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start fusion-flex-content-wrap\" style=\"max-width:calc( 1200px + 0px );margin-left: calc(-0px \/ 2 );margin-right: calc(-0px \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion_builder_column_1_1 1_1 fusion-flex-column\" style=\"--awb-bg-size:cover;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:0px;--awb-margin-bottom-large:20px;--awb-spacing-left-large:0px;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:0px;--awb-spacing-left-medium:0px;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:0px;--awb-spacing-left-small:0px;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-form-field fusion-form-email-field fusion-form-label-above\" style=\"\" data-form-id=\"2378\"><div class=\"fusion-form-label-wrapper\"><label for=\"epost\">Your email address <abbr class=\"fusion-form-element-required\" title=\"required\">*<\/abbr><\/label><\/div><input type=\"email\" autocomplete=\"off\" name=\"epost\" id=\"epost\" value=\"\"  class=\"fusion-form-input\" required=\"true\" aria-required=\"true\" placeholder=\"name@company.com *\" data-holds-private-data=\"false\"\/><\/div><div class=\"fusion-form-field fusion-form-consent-field fusion-form-label-above\" style=\"\" data-form-id=\"2378\"><div class=\"fusion-form-label-wrapper\"><label for=\"samtycke\">Consent <abbr class=\"fusion-form-element-required\" title=\"required\">*<\/abbr><\/label><\/div><div class=\"fusion-form-checkbox option-inline\"><input tabindex=\"\" id=\"samtycke\" type=\"checkbox\" value=\"1\" name=\"samtycke\" class=\"fusion-form-input\" required=\"true\" aria-required=\"true\"\/><label for=\"samtycke\"><\/label><\/div><\/div><div class=\"fusion-form-field fusion-form-submit-field fusion-form-label-above\" style=\"\" data-form-id=\"2378\"><div ><button type=\"submit\" class=\"fusion-button button-flat fusion-button-default-size button-default fusion-button-default button-1 fusion-button-span-no  button-default form-form-submit\" data-form-number=\"2378\" tabindex=\"\"><span class=\"fusion-button-text awb-button__text awb-button__text--default\">Send me the PDF<\/span><\/button><\/div><\/div><\/div><\/div><\/div><\/div><\/form><\/div>\n<p style=\"text-align: center;\"><em>Created by Lukas Lilja, VBA consultant since 2010.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The VBA Reference Card \u2014 Cheat Sheet for Beginners The  [&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-2072","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.exceldepartment.com\/en\/wp-json\/wp\/v2\/pages\/2072","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.exceldepartment.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.exceldepartment.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.exceldepartment.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.exceldepartment.com\/en\/wp-json\/wp\/v2\/comments?post=2072"}],"version-history":[{"count":0,"href":"https:\/\/www.exceldepartment.com\/en\/wp-json\/wp\/v2\/pages\/2072\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.exceldepartment.com\/en\/wp-json\/wp\/v2\/media?parent=2072"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}