officedev / vba-content

All content in this repository has been migrated to a new repository (https://github.com/MicrosoftDocs/VBA-Docs). Please do not open issues or pull requests here. We are no longer monitoring this content.

VBA

The content in the VBA repository is grouped first by product, then by topic. The README.md file at the root of each topic directory specifies the structure of the articles within the topic.

For information about how to contribute to the VBA documentation, see Contributing.md.

Download the VBA references

In addition to the online reference content for VBA, we also have offline copies for some of the products. Note that these offline CHMs represent a snapshot of the content as of 11/06/2015; for the latest updates, always view the content on GitHub or MSDN.

The VBA references available include:

• Access - Download ACVBACon.chm
• Excel - Download XLVBACon.chm
• PowerPoint - Download PPVBACon.chm
• Word - Download WDVBACon.chm

To open the CHM file, double-click the file in Windows Explorer at the disk location where you last saved it.

Troubleshooting: If No Content is Shown When You Open the CHM file

Note: The CHM file must be on your local drive.

If the reading pane is empty when you select a node in the help file’s table of contents, do the following to resolve the issue:

1. Close the CHM file.
2. In Windows Explorer, right click the CHM file, and then click Properties.
3. Click Unblock, and then click OK.
4. Double-click the CHM file to open it.

Copyright

Copyright (c) 2016 Microsoft Corporation. All rights reserved.

This project has adopted the Microsoft Open Source Code of Conduct. For more information, see the Code of Conduct FAQ or contact [email protected] with any additional questions or comments.

vba-content's Issues

Several files have merge conflict markers in them

Some examples:
https://github.com/OfficeDev/VBA-content/blob/master/VBA/Word-VBA/readme.md
https://github.com/OfficeDev/VBA-content/blob/master/VBA/Excel-VBA/readme.md

I'd suggest auditing all files by searching for "<<<<<<< HEAD".

cc @laschultz

Intersect documentation needs clarification

This function (perhaps Union as well?) crashes with a 1004 Run Time application error if the ranges are on different worksheets. This is not an unlikely error as a common use of this function includes the Target range from the Worksheet_Change event, which can be caused when VBA code updates cell(s) on a non-Active worksheet.

The documentation should note this constraint.

Special characters have been replaced by question marks

Some files contain multiple question marks, where, presumably, there was originally other characters that have been lost to encoding changes

It's not always clear what the ? was originally, but in many cases, the ? was an operator, so reinstating the correct character is both difficult and critical.

See this example:

- Make sure that you are consistent about the units you use for specifying rate and nper. If you make monthly payments on a four-year loan at an annual interest rate of 12 percent, use 12%/12 for rate and 4*12 for  _Arg2_ . If you make annual payments on the same loan, use 12% for rate and 4 for _Arg2_ .

-  _Arg2_ , _Arg4_ , _Arg5_ , and type are truncated to integers.

- If rate ? 0,  _Arg2_ ? 0, or _Arg3_ ? 0, CumIPmt generates an error.

- If  _Arg4_ < 1, _Arg5_ < 1, or _Arg4_ > _Arg5_ , CumIPmt generates an error.

- If  _Arg6_ is any number other than 0 or 1, CumIPmt generates an error.

Cant access address book through Outlook VB using example in the docs

The example in the docs gives compilation errors. At this point all I have left to do is trial and error. Please assist. All I want to do is populate a ComboBox with the names in the address book. Either that or use the addressbook popup to select a name that will then show up in the field. Whatever is easier.

Some bold member names (and headings) have an unnecessary leading space

For example

Settings
The default setting for a control is a unique name based on the type of control. For example, CommandButton1 is the default caption for the first command button in a form.
Remarks
The text identifies or describes the object with which it is associated. For buttons and labels, the Caption property specifies the text that appears in the control. For Page and Tab objects, it specifies the text that appears on the tab.
If a control's caption is too long, the caption is truncated. If a form's caption is too long for the title bar, the title is displayed with an ellipsis.
The ForeColor property of the control determines the color of the text in the caption.

Tip If a control has both the Caption and AutoSize properties, setting AutoSize to True automatically adjusts the size of the control to frame the entire caption.

The Settings, Remarks, Caption, ForeColor and Tip keywords all have leading spaces, which usually results in 2 spaces, so while browsers won't usually render consecutive spaces, there's room for improvement in the underlying source, for situations where the leading space will be rendered unintentionally.

Missing reference for parameter CodePage

For DoCmd.TransferText, a link should be provided to the reference for the possible values of the last parameter: CodePage

That reference is found at a different site, the Windows documentation: Code Page Identifiers

Further, the example code ignores this important parameter completely.

Problems with TextRange2

I'm writing an add-in for PowerPoint 2013 with C#.
I think here in bce672a4-b108-b223-7e65-71f07d7f4197.md the return type of TextRange method should be TextRange2. It took me some time to figure this out and it confused me. Is that an error in the document or C# and VBA are different? TextRange2 is not even listed in the index.
And I guess probably there are errors elsewhere where xxx should be xxx2.

Presentation.SaveAs confusing PpSaveAsFileType

In file VBA/PowerPoint-VBA/articles/d70a678b-66ed-9dd6-5a5e-454cdf808784.md (Presentation.SaveAs), the example at the button uses ppSaveAsPowerPoint4 while the list of all possible PpSaveAsFileType does not have this entry.

It would also be helpful to have a short description what each of these constants means.

ActivateTab sometimes returns undocumented S_FALSE (in C++)

Documentation says nothing about cases when ActivateTab can return S_FALSE.

Index is missing

Hi,

just to note, that generated chm files, miss indexes. Hopefully indexes exist.

Version-related contributions

I am interested in contributing to this repository, partly to document Mac/Windows differences - as you may know, most of the Mac VBA-specific documentation disappeared from the web a couple of years ago.

However,
a. I see that there is little or no version-specific information in the entries for objects, properties etc., and I don't see an established convention for specifying which version contains what.

b. it is not completely obvious which versions you are targetting. I would guess that Microsoft's focus is on the 2016 versions on Windows and Mac, and probably earlier supported Windows versions, but Mac developers have not had access to reliable 2011 documentation for some time, and discovery of what is and is not in Office for Mac VBA 2016 is largely a matter of trial and error, given the current state of the VBA IDE. IMHO documentation of this kind should really aim to be as comprehensive a reference as possible, even documenting unsupported versions if someone is willing to contribute the information.

c. If you are syncing the material with MSDN, there could well be a serious problem where different parts of the documentation are in very different states (e.g., some pointing out Windows/Mac differences, and others not).

Please advise!

Inconsistent Labeling

Is labeled "PivotTable.Slicers Property" but is described (properly) as a Collection. This inconsistency in labeling occurs throughout the PivotTable object documentation. It is very misleading and could cause unnecessary confusion to some. As for me, I just learn to not trust the documentation - kind of antithetical to the purpose of documentation. :)

Mistake in the VBA-Excel documentation

I am trying to change the position of existing page breaks in Excel with VBA. According to the documentation (VPageBreak.Location, HPageBreak.Location), this would be achieved with the following code:

Worksheets(1).VPageBreaks(1).Location = Worksheets(1).Range("e5")
Worksheets(1).HPageBreaks(1).Location = Worksheets(1).Range("e5")

However, when I tried that syntax, I got no results. No errors, but no change either.

After some Googling, it seems I'm not the only one having this issue:
http://www.pcreview.co.uk/threads/recorded-macro-to-set-page-breaks-generates-error.998729/
https://groups.google.com/forum/#!topic/microsoft.public.excel.programming/M7jSrjlvtT8
http://www.xtremevbtalk.com/archive/index.php/t-240387.html
http://www.excelforum.com/excel-programming-vba-macros/473696-moving-horizontal-pagebreak.html
https://www.mathworks.com/matlabcentral/newsreader/view_thread/299034?requestedDomain=www.mathworks.com

I did see a suggestion here to use Set, while in Page Break Preview mode:

Set Worksheets(1).HPageBreaks(1).Location = Worksheets(1).Range("e5")

That worked for HPageBreak. However, with VPageBreak, I got the following error:

Run-time error '1004':
Application-defined or object-defined error

If you record a macro and change a horizontal page break, VBA generates a macro using Set ActiveSheet.HPageBreaks(1).Location = Range("e5"), whereas if you change a vertical page break, it uses ActiveSheet.VPageBreaks(1).DragOff.

In summary:
It seems to me that VPageBreak.Location is read-only, and the documentation, along with its example, is incorrect. The only way to change the location of a VPageBreak is by using VPageBreak.DragOff.
HPageBreak.Location can be written to, however, only while in Page Break Preview mode, and only with Set.

Contribute using GitHub workflow is different for non collaborators

https://github.com/OfficeDev/VBA-content/blob/master/CONTRIBUTING.md

In step 5 of Contribute using GitHub, it states: ‘Select Create a new branch for this commit and start a pull request radio button.’ Can people who aren’t a collaborator do branch operations on a repo? I didn’t have that impression. My impression is that they would need to fork the repo to make the pull request. Please review this step and verify that this will work for non project collaborators.

QueryTable.Refresh has a huge memory leak on Mac

Currently on Excel 64-bits for Mac this function call causes excel to become unresponsive and starts eating memory nonstop, allocating 60GB in around a minute.

Length of Bookmark.Name in Word

Please document that in Microsoft Word the Name argument for Bookmarks.Add()* should not exceed 40 characters, as Bookmark.Name* is limited to this length, therefore the Name argument for Bookmarks.Exists()* should not exceed 40 characters accordingly or might otherwise lead to unexpected results.

WindowBeforeRightClick event has been fixed for Word 2016

In a previous revision to the WindowBeforeRightClick event for Word 2016, you had added the notation "The WindowBeforeRightClick event is not available for Word 2016." This was correct at the time, because the event was broken and unavailable to Word 2016 developers for many months. But this was just recently fixed by Microsoft, so the event DOES now work as expected with Word 2016.

Cannot find all the Microsoft Excel VBA classes - where are they defined?

The Java Development Kit has a listing of all the Java classes, containing the Java defined keyword elements and functions.
I assumed that the Excel VBA would have a similar listing of all the Microsoft defined classes but am unable to find such a repository. Since writing a macro using reserved words of Excel objects is common, where do I find such a complete listing that I may refer to?
Thanks,
Dan

Reference doesn't work Office-Mac-VBA.

is there any working references for Office-Mac-VBA. any of link does not work
ex :
https://github.com/OfficeDev/VBA-content/blob/master/Office-Mac-VBA/articles/AppleScriptTask.md

Document how to call shared libraries on Excel 2016 from add-in

I gather that sandboxing has been added to Excel 2016 add-ins on OSX. This breaks add-ins that have in their header something like:

Option Explicit
#If Mac Then
Private Declare Function PropsSI_private Lib "libCoolProp.dylib" Alias "PropsSI" (ByVal Output As String, ByVal Name1 As String, ByVal Value1 As Double, ByVal Name2 As String, ByVal Value2 As Double, ByVal Ref As String) As Double
Private Declare Function PhaseSI_private Lib "libCoolProp.dylib" Alias "PhaseSI" (ByVal Name1 As String, ByVal Value1 As Double, ByVal Name2 As String, ByVal Value2 As Double, ByVal Ref As String, ByVal Output As String, ByVal n As Integer) As Long
...

because at add-in load time, we can't call any functions before the shared library is tried to be loaded.

Previously we just needed to make sure that the correct shared library was in ~/lib, but that no longer works. How do we modify our add-in to defeat the sandboxing and allow us to call the shared library?

If I have asked this question in the wrong place, please direct me to the appropriate location.

Usage guidelines omit spaces

VBA-Content usage expressions include underscore characters

_result_**=**_expression1_**&**_expression2_

which render, without spaces, as:

result=expression1&expression2

But the online help page here uses this HTML, which includes spaces:

<p> <em>result </em> <strong>= </strong> <em>expression1 </em> <strong>&amp; </strong> <em>expression2</em> </p>

which renders, including spaces, as:

result = expression1 & expression2

The true VBA syntax should include spaces, so the project markdown should use:

_result_ **=** _expression1_ **&** _expression2_

which will render as:

result = expression1 & expression2

If the user does SAVE AS and then hits cancel, Excel still sets the CANCEL boolean to FALSE.

This is my first post here so maybe I'm doing this wrong but...

If the user chooses File > Save As and then hits cancel, Excel still sets the CANCEL boolean to FALSE. However, if the user makes changes, quits, and declines to save changes, Excel correctly sets the CANCEL boolean to True.

Perhaps I am using the CANCEL boolean the wrong way. If it is merely a switch that is provided to us to allow us to disable a save action, then I am using it the wrong way. (The description of the boolean at https://msdn.microsoft.com/en-us/library/office/ff840057.aspx does say it is "False when the event occurs" which implies that it is set to True when the event does not occur. Perhaps the docs should clarify which event.)

Even if I am using it the wrong way, it does seem like there's a need here for a flag that would indicate the difference between a user starting the save process and a user actually approving the save action because those create materially different outcomes.

Unicode Support?

Regarding ClipBoard_SetData:
I'm a noob, so I could be missing something simple, but it seems to me that using the windows API to put a string containing Unicode characters doesn't work as expected. It replaces all the characters with question marks (?).

I've got VBA code (used in Excel) that takes the contents of a cell and puts the text value in the clipboard.
For example: lets say A1 contains =UNICHAR(1234)
The code would be:
x = ClipBoard_SetData(Range("A1").Value)
and the result would be that the clipboard contains a question mark (?)

Any ideas how to modify the code to get Unicode characters working?

I've tried changing the value of CF_TEXT from 1 to 13 as per this link, however this instead put a series of strange characters into the clipboard, even with a normal non-Unicode string.

addressEntry method returing wrong address book entry for exchange user string

before calling GetExchangeUser() Method for Address entry, setting AddressEntry object for Exchange user string resulting to wrong email address or any other exchange user details.

For instance, we want email address of exchange users who's entries are available in outlook address book so if there is entry for user "Jai" in outlook address book that is also exchange user and if we are passing exchange user string representing user "Jack" who's entry is not available in outlook address book resulting email address of "Jai" rather than Null.

This is absolute bug with this method which is taking string comparison based on character set and if not found returning first entry based on first letter of user string that we are passing.

Selection.Collapse Method (Word): constants not defined (C++)

(I'm on VS15 Community, v14.0.x Update 1).

This article directs developers to use the WdCollapseDirection constants, but these are not defined in the C++ headers.

Alternatively, wdCollapseEnd = 1, wdCollapseStart = 0.

A Word automation example/snippet:

// This uses AutoWrap() from Solution2.cpp in the CppAutomateWord sample project at
// https://code.msdn.microsoft.com/office/CppAutomateWord-14799966

IDispatch *o_Selection; // set this to your Selection object ...
...
    VARIANT param, ret;
        VariantInit(&param);
        VariantInit(&ret);
    param.vt = VT_INT;
    param.lVal = 0; // 0 = end, 1 = start
    HRESULT hr = AutoWrap(DISPATCH_METHOD, &ret, o_Selection, L"Collapse", 1, param);
    if (FAILED(hr)) {
            wprintf(L"msl_IDispatch Selection::Compress failed with error 0x%x08l.\n", hr);
            return E_FAIL;
    }
...

Access 2016 does not convert

Does not work in access 2016

Read Only error when merging excel files

When I run the code it says there is a compile error: cant assign to read-only property

Sub GetSheets()
Path = "C:\Users\H\Desktop\AMORT"
Filename = Dir(Path & " hi.xls")
Do While Filename <> ""
Workbooks.Open Filename:=Path & Filename, ReadOnly:=True
For Each Sheet In ActiveWorkbook.Sheets
Sheet.Copy After:=ThisWorkbook.Sheets(1)
Next Sheet
Workbooks(Filename).Close
Filename = Dir()
Loop
End Sub

Missing information in Custom Document Properties article

VBA-content / Office-Shared-VBA / articles / 80738562-8b0b-33f1-3dfa-0d66b1844ef7.md

The LinkSource information is incomplete. WHAT are valid link sources for each application? Please give code examples that actually WORK.

Remark in MailItem.ConversationID topic is stripped of version number inappropriately

The topic is at https://msdn.microsoft.com/en-us/library/ff867895.aspx.

In the Remarks section, the phrase "If the MailItem object is created in a version of Microsoft Outlook earlier than Outlook, or if..." is missing a version indicator for "Outlook". The version is Outlook 2010 - ConversationID was introduced in Outlook 2010.

Asterisks are not Markdown escaped

Pages that use an asterisk character (*) do not have the asterisk character escaped, which corrupts the markdown.
See this example

To escape an asterisk, the asterisk should be escaped with a backslash \

Navigation Button Shape properties not correct

VBA-content/Access-VBA/articles/9d9ecd73-b1a4-6861-a420-3bc52beae95c.md

https://msdn.microsoft.com/en-us/library/office/ff198250.aspx

The allowed NagivationButton.Shape value in reality (Office 2016 up to date as of June 2016) only go from 0 (defualt) to 7 (oval) NOT up to 9 as the page lists. These values are valid for Command Buttons, but are not correct for Navigation buttons.

Syntax highlighting

It would be great to have syntax highlighting on MSDN. I feel like I've seen it on some pages, but there are several that are not highlighted. E.g., https://msdn.microsoft.com/en-us/library/office/ff823060.aspx. Since I'm not sure what the build process/system is for these files, it's hard for me to suggest possible solutions, but one relatively low-effort option would be to include highlight.js

Maybe add a page for Font.Color Property (Word)

Maybe add a page for Font.Color Property (Word), like the page _Font.Color property.

The Color property is available but doesn't appear on the page Font Properties (Word), only on the page Font properties.

(Or, if the Color property is deprecated, then change its description on the page Font properties, like the description of the Animation property that is deprecated.)

Two "Glossary" pages

There's two glossary pages:

• Glossary (Microsoft Forms) - 6c8b42d0-e2f1-4582-af57-323df0b79195.md
• Glossary (VBA) - 7ce2c60f-29fb-96e2-2516-73c99a6e7cff.md

The first page just consists of a link to the second page. This seems a bit silly, and I think the first one should instead just redirect to the second one.

Links after 'The VBA references available include' in README are broken.

Links go to Github 404.

Workbook.SaveCopyAs Method (Excel) returns Run-time error '1004'

It is Office 2016 Mac OS edition issue.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    Dim FilenameStr As String
    FilenameStr = Sheet1.Range("F11").Value
    FilenameStr = ActiveWorkbook.Path & "/" & FilenameStr & "_" & Sheet1.Range("I5").Value

Or this as an alternative for the previous line

    FilenameStr = FilenameStr & "_" & Sheet1.Range("I5").Value

At this point I get the FilenameStr like this
/Users/myusername/somedir/123456789_20130531-002

    ActiveWorkbook.SaveCopyAs (FilenameStr & ".xls")
    Cancel = True
End Sub

This is the error I'm getting
Run-time error '1004': Cannot access read-only document 123456789_20130531-002.xls

The file doesn't exist and has to be created, but everythig worked back in Office 2011.

DatabaseType does not default to "Microsoft Access"

While testing this function, I found out you had to include this parameter with the "Microsoft Access" value in order to execute the function.

Otherwise, a 2057 error is thrown when trying to import/export/link to an Access database.

Example references of this issue:
http://www.pcreview.co.uk/threads/run-time-error-2507.3780386/
http://www.access-programmers.co.uk/forums/showthread.php?t=274207

Word-VBA Field.Update documentation: return value inconsistent

The Field.Update document says that the return value is True on success, and later says the return value is 0 on success. CLng(False)=0, so it can't be both :) . On my Word 2013 install, the Object Browser shows Field.Update as returning Boolean, True appears to be the return value for success, and False appears to be the return value for failure. Would you please confirm and correct the document? Thank you!

.save changes the current directory to documents area even if document is being saved elsewhere

You need to at least document that using .save will cause the current directory to change to where your documents are stored even if the file you are saving is elsewhere. This causes to any code that relies on relative paths. You must save off the current director and use chdir and chdrv (chdir will not change the current drive even if it is in the chdir command) to restore

Bad link in "Revisions object"

Hi,

In the Revision object (7f267a64-885a-cb4c-008a-e8545cea94d2.md) and Revision Object Members (../97eb185c-125a-1c5f-6f54-157fd5bbf355.md) articles:

The link Revision object point to SmartArtLayout Object (../f8d9db83-86f7-4830-096d-5d15368ab6b1.md). The target article should be "e6f64467-a438-88f1-60f9-975365a1430e.md".

Could you fix that?

Range.RemoveDuplicates does not specify default behavior

Range.RemoveDuplicates Method

columns is an optional argument to this method, but no information is given as to what happens if the argument is not supplied.

AppleScriptTask causes grey box to appear & disappear

Issue occurs whenever I use AppleScriptTask in Word 2016 (15.18 build 160109). I'm including an example applescript (and the macro calling it) as well as a screenshot demonstrating the problem.

"vlc_step_backward.scpt" is an example script used to send a test command (step-backward) to VLC from a word 2016 macro. As required by the AppleScriptTask command, the file "vlc_step_backward.scpt" (path: "/Users/venkat/Library/Application Scripts/com.microsoft.Word/") includes the relevant command inside of a script handler, and executes without spawning the gray window:

on vlc_stepback_handler()
tell application "VLC" to step backward
end vlc_stepback_handler

Here is the Macro in Office 2016 to call "vlc_step_backward.scpt":

Sub VLCStepBack()
'
' VLCStepBack Macro
'
'
Dim myScriptResult As String
myScriptResult = AppleScriptTask("vlc_step_backward.scpt", "vlc_stepback_handler", "")
End Sub

AppleScriptTask causes a grey square window to appear and disappear (as pictured below).

The error is not specific to VLC -- for example, it persists if "vlc_step_backward.scpt" is modified to control iTunes instead:

on vlc_stepback_handler()
tell application "iTunes" to play
end vlc_stepback_handler

Has anyone noticed a similar grey box? Could anyone recommend any work-arounds?

Best,

Venkat

AutoFormatAsYouTypeApplyFirstIndents not working

When I run the following code, it is not changing the "Set left- and first-indent with tabs and backspaces" under Options > Proofing > AutoCorrect Options... > AutoFormat As You Type

objOptions.AutoFormatAsYouTypeApplyFirstIndents = FALSE

Is this the correct object name?

Using .location with Excel 2007

This is more of a question than an issue.. I tried .location in an Excel 2007 workbook and it works just fine on my laptop, but my users got an error on it 1004

The specified dimension is not valid for the current chart type.

Am I dead in the water?

Thanks!

VBA WindowBeforeRightClick event

It should be noted that the WindowBeforeRightClick event no longer is functional as of Word 2016.

Links to Glossary pages often omit a leading space

There are 930 pages with links to the glossary. Many of those links are missing a leading space before the link.

For example
Properties Window Command (View Menu)

Displays the Properties window, which lists the design-time properties for a selectedform, control, class, project ormodule.

Notice the missing spaces before form and module, but not before control, class and project

And in this example
Interface not valid for Implements

• The interface contains some element that can't be supported by Visual Basic. For example, Visual Basic has no equivalent to the unsigned long integer type, Visual Basic can't designate a procedureparameter as "out-only." Although Visual Basic supports the use of the underscore character (_) in Visual Basicidentifiers, it can't implement an interface that uses underscore characters in the names of its members.

Notice the missing space before parameter and identifiers, but not before procedure

Unit missing in .Height and .Width properties

Would be nice to know if e.g. .Width is in twips or pixel or meter :-) on all objects: Application, Table, Range, ...

access

does any know how to increase the short text 255 max word without going to long text. The software would not allow me to increase the text and it erases what every is inputted into the data base when you you try switching to long text.

Catching events doesn't work as advertised

I have a problem with this basic tutorial: https://github.com/OfficeDev/VBA-content/blob/master/Outlook-VBA/articles/560bb264-05d0-dbc6-39c2-b95b12f50ed9.md

Also hosted on msdn: https://msdn.microsoft.com/en-us/library/bb206733.aspx

I produced following code, placed in ThisOutlookSession:

Dim WithEvents myOlBar As Outlook.OutlookBarPane

Private Sub Application_NewMail()
    MsgBox "New mail"
End Sub
Private Sub myOlBar_BeforeNavigate(ByVal Shortcut As OutlookBarShortcut, Cancel As Boolean)
    MsgBox Shortcut.Name
End Sub

Private Sub Application_Startup()
 Set myOlBar = Application.ActiveExplorer.Panes(1)
End Sub

I enabled macros:

I confirmed that I allow macros after outlook restart:

Still I get no effect whatsoever. However if I put some debug code in application startup callback, it works - I can print Hello world on startup:

Private Sub Application_Startup()
   MsgBox "Hello world!"
End Sub

So why is startup the only callback that works?

Special characters in code samples are HTML encoded

The VBA and HTML/VBScript examples include code blocks escaped with ``` code blocks, which result in <pre> tags in GitHub renderings. That means that encoding inside the code blocks should not be HTMLEncoded.

VBA Example
This file has ampersand & concatenation operators, but they've been HTML encoded.

.Cells(lnRow, 2).Value = "'" & lnCount & "-" & lnPages 

The line should read:

.Cells(lnRow, 2).Value = "'" & lnCount & "-" & lnPages 

HTML example
For example, this file's HTML include > HTML entities, but they're corrupted by being HTMLEncoded:

<OPTION VALUE="&amp;gt;">&amp;gt;</OPTION><OPTION VALUE="&amp;lt;">&amp;lt;</OPTION>

The line should read as:

<OPTION VALUE="&gt;">&gt;</OPTION><OPTION VALUE="&lt;">&lt;</OPTION>

I haven't checked every code example, but this problem would seem to exist on all pages that involve code samples.

Copying code samples into a VB Editor results in corrupt code.