\documentclass[10pt,a4paper]{article}

% Packages
\usepackage{fancyhdr}           % For header and footer
\usepackage{multicol}           % Allows multicols in tables
\usepackage{tabularx}           % Intelligent column widths
\usepackage{tabulary}           % Used in header and footer
\usepackage{hhline}             % Border under tables
\usepackage{graphicx}           % For images
\usepackage{xcolor}             % For hex colours
%\usepackage[utf8x]{inputenc}    % For unicode character support
\usepackage[T1]{fontenc}        % Without this we get weird character replacements
\usepackage{colortbl}           % For coloured tables
\usepackage{setspace}           % For line height
\usepackage{lastpage}           % Needed for total page number
\usepackage{seqsplit}           % Splits long words.
%\usepackage{opensans}          % Can't make this work so far. Shame. Would be lovely.
\usepackage[normalem]{ulem}     % For underlining links
% Most of the following are not required for the majority
% of cheat sheets but are needed for some symbol support.
\usepackage{amsmath}            % Symbols
\usepackage{MnSymbol}           % Symbols
\usepackage{wasysym}            % Symbols
%\usepackage[english,german,french,spanish,italian]{babel}              % Languages

% Document Info
\author{CJinDenver}
\pdfinfo{
  /Title (excel-vba-editor.pdf)
  /Creator (Cheatography)
  /Author (CJinDenver)
  /Subject (Excel VBA Editor Cheat Sheet)
}

% Lengths and widths
\addtolength{\textwidth}{6cm}
\addtolength{\textheight}{-1cm}
\addtolength{\hoffset}{-3cm}
\addtolength{\voffset}{-2cm}
\setlength{\tabcolsep}{0.2cm} % Space between columns
\setlength{\headsep}{-12pt} % Reduce space between header and content
\setlength{\headheight}{85pt} % If less, LaTeX automatically increases it
\renewcommand{\footrulewidth}{0pt} % Remove footer line
\renewcommand{\headrulewidth}{0pt} % Remove header line
\renewcommand{\seqinsert}{\ifmmode\allowbreak\else\-\fi} % Hyphens in seqsplit
% This two commands together give roughly
% the right line height in the tables
\renewcommand{\arraystretch}{1.3}
\onehalfspacing

% Commands
\newcommand{\SetRowColor}[1]{\noalign{\gdef\RowColorName{#1}}\rowcolor{\RowColorName}} % Shortcut for row colour
\newcommand{\mymulticolumn}[3]{\multicolumn{#1}{>{\columncolor{\RowColorName}}#2}{#3}} % For coloured multi-cols
\newcolumntype{x}[1]{>{\raggedright}p{#1}} % New column types for ragged-right paragraph columns
\newcommand{\tn}{\tabularnewline} % Required as custom column type in use

% Font and Colours
\definecolor{HeadBackground}{HTML}{333333}
\definecolor{FootBackground}{HTML}{666666}
\definecolor{TextColor}{HTML}{333333}
\definecolor{DarkBackground}{HTML}{4D88FF}
\definecolor{LightBackground}{HTML}{F3F7FF}
\renewcommand{\familydefault}{\sfdefault}
\color{TextColor}

% Header and Footer
\pagestyle{fancy}
\fancyhead{} % Set header to blank
\fancyfoot{} % Set footer to blank
\fancyhead[L]{
\noindent
\begin{multicols}{3}
\begin{tabulary}{5.8cm}{C}
    \SetRowColor{DarkBackground}
    \vspace{-7pt}
    {\parbox{\dimexpr\textwidth-2\fboxsep\relax}{\noindent
        \hspace*{-6pt}\includegraphics[width=5.8cm]{/web/www.cheatography.com/public/images/cheatography_logo.pdf}}
    }
\end{tabulary}
\columnbreak
\begin{tabulary}{11cm}{L}
    \vspace{-2pt}\large{\bf{\textcolor{DarkBackground}{\textrm{Excel VBA Editor Cheat Sheet}}}} \\
    \normalsize{by \textcolor{DarkBackground}{CJinDenver} via \textcolor{DarkBackground}{\uline{cheatography.com/100087/cs/21067/}}}
\end{tabulary}
\end{multicols}}

\fancyfoot[L]{ \footnotesize
\noindent
\begin{multicols}{3}
\begin{tabulary}{5.8cm}{LL}
  \SetRowColor{FootBackground}
  \mymulticolumn{2}{p{5.377cm}}{\bf\textcolor{white}{Cheatographer}}  \\
  \vspace{-2pt}CJinDenver \\
  \uline{cheatography.com/cjindenver} \\
  \end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
  \SetRowColor{FootBackground}
  \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Cheat Sheet}}  \\
   \vspace{-2pt}Published 18th November, 2020.\\
   Updated 18th November, 2020.\\
   Page {\thepage} of \pageref{LastPage}.
\end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
  \SetRowColor{FootBackground}
  \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Sponsor}}  \\
  \SetRowColor{white}
  \vspace{-5pt}
  %\includegraphics[width=48px,height=48px]{dave.jpeg}
  Measure your website readability!\\
  www.readability-score.com
\end{tabulary}
\end{multicols}}




\begin{document}
\raggedright
\raggedcolumns

% Set font size to small. Switch to any value
% from this page to resize cheat sheet text:
% www.emerson.emory.edu/services/latex/latex_169.html
\footnotesize % Small font.

\begin{multicols*}{3}

\begin{tabularx}{5.377cm}{p{0.64701 cm} x{4.32999 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Ctrl + Letters}}  \tn
% Row 0
\SetRowColor{LightBackground}
\seqsplit{Ctrl+A} & Select all text in the current module. \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
\seqsplit{Ctrl+C} & Copies the selection to the clipboard. \tn 
% Row Count 4 (+ 2)
% Row 2
\SetRowColor{LightBackground}
\seqsplit{Ctrl+E} & Displays the (File \textgreater{} Export File) dialog box. \tn 
% Row Count 6 (+ 2)
% Row 3
\SetRowColor{white}
\seqsplit{Ctrl+F} & Displays the (Edit \textgreater{} Find) dialog box. \tn 
% Row Count 8 (+ 2)
% Row 4
\SetRowColor{LightBackground}
\seqsplit{Ctrl+G} & Displays the (View \textgreater{} Immediate window) window. \tn 
% Row Count 10 (+ 2)
% Row 5
\SetRowColor{white}
\seqsplit{Ctrl+H} & Displays the (Edit \textgreater{} Replace) dialog box. (Find/Replace) \tn 
% Row Count 12 (+ 2)
% Row 6
\SetRowColor{LightBackground}
\seqsplit{Ctrl+I} & Turn on quick information (Edit \textgreater{} Quick Info). \tn 
% Row Count 14 (+ 2)
% Row 7
\SetRowColor{white}
\seqsplit{Ctrl+J} & Displays a drop-down of available properties (Edit \textgreater{} List Properties/Methods). \tn 
% Row Count 17 (+ 3)
% Row 8
\SetRowColor{LightBackground}
\seqsplit{Ctrl+L} & Show the call stack (View \textgreater{} Call Stack). \tn 
% Row Count 19 (+ 2)
% Row 9
\SetRowColor{white}
\seqsplit{Ctrl+M} & Displays the (File \textgreater{} Import File) dialog box. \tn 
% Row Count 21 (+ 2)
% Row 10
\SetRowColor{LightBackground}
\seqsplit{Ctrl+N} & Inserts a new line and positions the cursor at the start of the line. Pressing Enter will maintain the same indentation. \tn 
% Row Count 25 (+ 4)
% Row 11
\SetRowColor{white}
\seqsplit{Ctrl+P} & Displays the (File \textgreater{} Print) dialog box. \tn 
% Row Count 27 (+ 2)
% Row 12
\SetRowColor{LightBackground}
\seqsplit{Ctrl+R} & Displays the (View \textgreater{} Project Explorer) window. \tn 
% Row Count 29 (+ 2)
% Row 13
\SetRowColor{white}
\seqsplit{Ctrl+S} & Saves (File \textgreater{} Save). \tn 
% Row Count 31 (+ 2)
\end{tabularx}
\par\addvspace{1.3em}

\vfill
\columnbreak
\begin{tabularx}{5.377cm}{p{0.64701 cm} x{4.32999 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Ctrl + Letters (cont)}}  \tn
% Row 14
\SetRowColor{LightBackground}
\seqsplit{Ctrl+T} & Displays the Components dialog box listing all the available components. This is a Visual Basic 6.0 dialog box. \tn 
% Row Count 4 (+ 4)
% Row 15
\SetRowColor{white}
\seqsplit{Ctrl+V} & Pastes the current clipboard entry. \tn 
% Row Count 6 (+ 2)
% Row 16
\SetRowColor{LightBackground}
\seqsplit{Ctrl+X} & Cuts the selection to the clipboard. \tn 
% Row Count 8 (+ 2)
% Row 17
\SetRowColor{white}
\seqsplit{Ctrl+Y} & Cuts the entire line to the clipboard. \tn 
% Row Count 10 (+ 2)
% Row 18
\SetRowColor{LightBackground}
\seqsplit{Ctrl+Z} & Undo the last action (Edit \textgreater{} Undo). \tn 
% Row Count 12 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{p{0.4977 cm} x{4.4793 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Function Keys}}  \tn
% Row 0
\SetRowColor{LightBackground}
F1 & Stop code execution \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
F2 & Display Object Browser \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
F3 & Find next \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
F4 & Display Properties Window \tn 
% Row Count 4 (+ 1)
% Row 4
\SetRowColor{LightBackground}
F5 & Run currently selected code \tn 
% Row Count 5 (+ 1)
% Row 5
\SetRowColor{white}
F6 & Switch between split code windows \tn 
% Row Count 6 (+ 1)
% Row 6
\SetRowColor{LightBackground}
F7 & Displays code window \tn 
% Row Count 7 (+ 1)
% Row 7
\SetRowColor{white}
F8 & Step through code line by line \tn 
% Row Count 8 (+ 1)
% Row 8
\SetRowColor{LightBackground}
F9 & Insert or toggle break point \tn 
% Row Count 9 (+ 1)
% Row 9
\SetRowColor{white}
F10 & Toggles activation of menu bar \tn 
% Row Count 10 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{x{0.89586 cm} x{4.08114 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Shift + Function}}  \tn
% Row 0
\SetRowColor{LightBackground}
\seqsplit{Shift+F2} & Move to definition of procedure \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
\seqsplit{Shift+F3} & Find previous occurrence of last search \tn 
% Row Count 4 (+ 2)
% Row 2
\SetRowColor{LightBackground}
\seqsplit{Shift+F4} & Repeats last find (Find next) \tn 
% Row Count 6 (+ 2)
% Row 3
\SetRowColor{white}
\seqsplit{Shift+F7} & Toggle between userform and userform's code \tn 
% Row Count 8 (+ 2)
% Row 4
\SetRowColor{LightBackground}
\seqsplit{Shift+F8} & Step through code, and execute entire called procedure \tn 
% Row Count 10 (+ 2)
% Row 5
\SetRowColor{white}
\seqsplit{Shift+F9} & Activate watch window \tn 
% Row Count 12 (+ 2)
% Row 6
\SetRowColor{LightBackground}
\seqsplit{Shift+F10} & Display shortcut for menu for selected item \tn 
% Row Count 14 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{x{0.84609 cm} x{4.13091 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Ctrl + Function}}  \tn
% Row 0
\SetRowColor{LightBackground}
\seqsplit{Ctrl+F2} & Activates the Object Box in the top left corner of the Code window. \tn 
% Row Count 3 (+ 3)
% Row 1
\SetRowColor{white}
\seqsplit{Ctrl+F4} & Closes the active MDI child window. \tn 
% Row Count 5 (+ 2)
% Row 2
\SetRowColor{LightBackground}
\seqsplit{Ctrl+F5} & Runs the error handler code or returns the error to the calling procedure. Does not affect the setting for error trapping on the General tab. \tn 
% Row Count 10 (+ 5)
% Row 3
\SetRowColor{white}
\seqsplit{Ctrl+F6} & Moves to the next open window. This is exactly the same as (Ctrl + Tab). \tn 
% Row Count 13 (+ 3)
% Row 4
\SetRowColor{LightBackground}
\seqsplit{Ctrl+F8} & Run to the cursor. \tn 
% Row Count 15 (+ 2)
% Row 5
\SetRowColor{white}
\seqsplit{Ctrl+F9} & Moves the current line of execution to the selection for the next executed command. \tn 
% Row Count 18 (+ 3)
% Row 6
\SetRowColor{LightBackground}
\seqsplit{Ctrl+F10} & Activate the Menu bar. \tn 
% Row Count 20 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{x{1.29402 cm} x{3.68298 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Other + Function}}  \tn
% Row 0
\SetRowColor{LightBackground}
Alt+F4 & Closes the Visual Basic Editor window and returns to the application. \tn 
% Row Count 3 (+ 3)
% Row 1
\SetRowColor{white}
Alt+F5 & Resume execution though the error handler / run error handler. \tn 
% Row Count 6 (+ 3)
% Row 2
\SetRowColor{LightBackground}
Alt+F8 & Steps into the error handler or returns the error to the calling procedure. Does not affect the setting for error trapping on the General tab of the Options dialog box. \tn 
% Row Count 12 (+ 6)
% Row 3
\SetRowColor{white}
Alt+F11 & Toggles between the Visual Basic Editor and the application. \tn 
% Row Count 15 (+ 3)
% Row 4
\SetRowColor{LightBackground}
Ctrl+ Shift+F2 & Moves back to the previous position (View \textgreater{} Last Position). \tn 
% Row Count 18 (+ 3)
% Row 5
\SetRowColor{white}
Ctrl+ Shift+F8 & Step out of code. \tn 
% Row Count 20 (+ 2)
% Row 6
\SetRowColor{LightBackground}
Ctrl+ Shift+F9 & Clear all breakpoints from the active project. \tn 
% Row Count 22 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}


% That's all folks
\end{multicols*}

\end{document}