How to Post Your VBA Code

How to Post Your VBA Code

Quickly Wrap Selected Code

Simply select your code in the editor and click on <vba/> button on the editor toolbar to quickly wrap as VBA code.

Quick wrap as VBA code
Quick wrap as VBA code

You can also use <rich/> button on the editor toolbar if you'd like to stylize your code in the editor or your code contains BBCode tags (e.g. [B], [I], [COLOR]).

Insert Code Dialog Form

To insert code into a post:

  • Copy the code from the VBE.
  • Type your message in the post editor, and click Code button () on the editor toolbar.
Code button on the editor toolbar
Code button on the editor toolbar
  • Make sure VBA option is selected as language option in the "Insert code" dialog box, and paste your code into the text box.
Insert code dialog box
Insert code dialog box
  • Preferably you can click More Options and Preview your message to make sure your code looks as it is supposed to be.
Preview message
Preview message
  • You can also select Rich (BB Code) option if you'd like to stylize your code in the editor or your code contains BBCode tags (e.g. [B], [I], [COLOR]).
  • For the code snippets other than VBA, use the corresponding language option or General code.

Inline Code Entry

Sometimes you might want to post single line codes that you can put in your sentences. In this case:

  • Select the code line in your message.
Select code line
Select code line
  • Click Inline Code button () on the editor toolbar, and preview your message.
Inline Code button on the editor toolbar
Inline Code on the editor toolbar

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top