VBA AutoComplete

When you are typing code in the VBA code window you can press

Ctrl + Space Bar

to have Excel finish the word for you. Eg type

appli

And then press Ctrl + Space Bar to have Excel finish the word Application.