Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



BB Code

Explanation

BB code is a set of tags based on the HTML language that you may already be familiar with. They allow you to add formatting to your messages in the same way as HTML does, but have a simpler syntax and will never break the layout of the pages you are viewing. The ability to use BB code is set on a forum-by-forum basis by the administrator, so you should check the forum rules when you post a new message.

Below is a list of the BB code tags you can use to format your messages.

BB Code List

  1. Bold / Italic / Underline
  2. Color
  3. Size
  4. Font
  5. Highlight
  6. Left / Right / Center
  7. Indent
  8. Email Linking
  9. URL Hyperlinking
  10. Thread Linking
  11. Post Linking
  12. Bulleted Lists / Advanced Lists
  13. Images
  14. Videos
  15. Code
  16. PHP Code
  17. HTML Code
  18. Quote
  19. Stop BB Code Parsing
  20. Attachment
  21. ActiveData
  22. Advanced Filter
  23. AutoFilter
  24. Relative & Absolute Referencing
  25. Array Formula
  26. Access Videos
  27. Big Caps
  28. Blue Formula
  29. Blue Formula no heading
  30. Read Rules
  31. Cell
  32. Conditional Formatting
  33. Custom Number Formats
  34. Cross Posting
  35. Linked ComboBox Controls
  36. Double Line Break
  37. DON'T LIKE ALL THE ADS?
  38. Don't post
  39. Dynamic named range
  40. Excel Dates & Times
  41. Data Validation
  42. Dependend Validation Lists
  43. Enter Array Formula
  44. Excel Charts
  45. Excel Percentages
  46. Efficient Spreadsheet Design
  47. Excel Table
  48. Formula Tag
  49. How To Get Questions Answered
  50. FAQ
  51. Fill Handle
  52. Find Method
  53. Free Questions/Threads
  54. Forum Rules
  55. Formula Tag No Row/Column
  56. Signature Video
  57. GetOpenFileName
  58. Grid
  59. Google Search
  60. Add To Google Toolbar
  61. Hijack post
  62. Heading 1
  63. Heading 2
  64. Heading 3
  65. Heading 4
  66. Heading 5
  67. Hijack
  68. Hyperlinks
  69. Half Price Excel Course
  70. Solid Line
  71. InputBox
  72. IF Function
  73. iframe
  74. Justify
  75. Keyboard Button
  76. Last Cell In Range
  77. Lookup With Conditions
  78. Standard Macro Code
  79. Multi Condition Count
  80. Multi Condition Sum
  81. No Code Tags
  82. Number 1 Mistake By Excel Spreadsheet Users
  83. Named Ranges
  84. Free Training
  85. Overline
  86. Excel Object Model
  87. Run Macros On Time
  88. Proper Case
  89. Pivot Table
  90. PowerPoint Videos
  91. Related Data Validation Pages
  92. Record a Macro
  93. Run Macros On Protected Sheets
  94. Row
  95. Strikethrough
  96. Small Caps
  97. SpecialCells Method
  98. Sheet Code Name
  99. Select Case
  100. SUM Function
  101. Table Poster
  102. Subscibed Links
  103. NewThread
  104. SS
  105. Scroll Text
  106. Subscript
  107. Superscipt
  108. Post a Sample Workbook
  109. Track Changes Code
  110. Poor Thread Title
  111. Toggle
  112. Poor Thread Title
  113. Custom Functions
  114. Unformatted Code
  115. VBA Variables
  116. VLOOKUP
  117. Vlookup
  118. Workbook Module Code
  119. Worksheet Change Event
  120. Workbook Open Event
  121. Worksheet Module Code
  122. Spreadsheet
Incorrect BB Code Usage:
  • [url] www.example.com [/url] - don't put spaces between the bracketed code and the text you are applying the code to.
  • [email][email protected][email] - the end brackets must include a forward slash ([/email])

Bold / Italic / Underline

The [b], [i] and [u] tags allow you to create text that is bold, italic and underlined.

    • [b]value[/b]
    • [i]value[/i]
    • [u]value[/u]
    Usage
    • [b]this text is bold[/b]
    • [i]this text is italic[/i]
    • [u]this text is underlined[/u]
    Example Usage
    • this text is bold
    • this text is italic
    • this text is underlined
    Example Output

Color

The [color] tag allows you to change the color of your text.

  • [color=Option]value[/color]
    Usage
  • [color=blue]this text is blue[/color]
    Example Usage
  • this text is blue
    Example Output

Size

The [size] tag allows you to change the size of your text.

  • [size=Option]value[/size]
    Usage
  • [size=+2]this text is two sizes larger than normal[/size]
    Example Usage
  • this text is two sizes larger than normal
    Example Output

Font

The [font] tag allows you to change the font of your text.

  • [font=Option]value[/font]
    Usage
  • [font=courier]this text is in the courier font[/font]
    Example Usage
  • this text is in the courier font
    Example Output

Left / Right / Center

The [left], [right] and [center] tags allow you to change the alignment of your text.

    • [left]value[/left]
    • [center]value[/center]
    • [right]value[/right]
    Usage
    • [left]this text is left-aligned[/left]
    • [center]this text is center-aligned[/center]
    • [right]this text is right-aligned[/right]
    Example Usage
  • this text is left-aligned
    this text is center-aligned
    this text is right-aligned
    Example Output

Indent

The [indent] tag allows you to indent your text.

  • [indent]value[/indent]
    Usage
  • [indent]this text is indented[/indent]
    Example Usage
  • this text is indented
    Example Output

Email Linking

The [email] tag allows you to link to an email address. You can include an optional parameter to 'name' your link.

URL Hyperlinking

The [url] tag allows you to link to other websites and files. You can include an optional parameter to 'name' your link.

Thread Linking

The [thread] tag allows you to link to threads by specifying the thread id. You can include an optional parameter to 'name' your link.

    • [thread]threadid[/thread]
    • [thread=threadid]value[/thread]
    Usage
    • [thread]42918[/thread]
    • [thread=42918]Click Me![/thread]
    (Note: The threadid/postid is just an example and may not link to a valid thread/post.)
    Example Usage
  • Example Output

Post Linking

The [post] tag allows you to link to posts by specifying the post id. You can include an optional parameter to 'name' your link.

Bulleted Lists

The [list] tag allows you to create simple, bulleted lists without specifying an option. Within the value portion, each bullet is denoted by the [*] tag.

  • [list]value[/list]
    Usage
  • [list]
    [*]list item 1
    [*]list item 2
    [/list]
    Example Usage
    • list item 1
    • list item 2
    Example Output

Advanced Lists

The [list] tag allows you to create advanced lists by specifying an option. The option should have a value of 1 (for a numbered list) or A (for an alphabetic with capital letters list) or a (for an alphabetic with lowercase letters list) or I (for a numbered with capital Roman numeral list) or i (for a numbered with small Roman numeral list).

  • [list=Option]value[/list]
    Usage
  • [list=1]
    [*]list item 1
    [*]list item 2
    [/list]

    [list=A]
    [*]list item 1
    [*]list item 2
    [/list]

    [list=a]
    [*]list item 1
    [*]list item 2
    [/list]
    Example Usage
    1. list item 1
    2. list item 2
    1. list item 1
    2. list item 2
    1. list item 1
    2. list item 2
    Example Output

Images

The [img] tag allows you to embed images within your posts. You can also combine this tag with the [url] tag to make images become links.

  • [img]value[/img]
    Usage
    • [img]http://www.ozgrid.com/forum/images/statusicon/forum_new-48.png[/img] (Not linked)
    • [url=http://www.example.com] [img]http://www.ozgrid.com/forum/images/statusicon/forum_new-48.png[/img] [/url] (Linked)
    Example Usage
    • (Not linked)
    • (Linked)
    Example Output

Videos

The [video] tag allows you to embed videos from various video services within your posts.

  • [video]value[/video]
    Usage
    • [video=youtube;eOUq4Z6R7xI]http://www.youtube.com/watch?v=eOUq4Z6R7xI[/video]
    Example Usage
    Example Output

Code

The [code] and [vba] tags switch to a fixed-width (monospace) font, highlights keywords/comments and indents for clear display.

  • [code]value[/code]
    Usage
  • [code]
    <script type="text/javascript">
    <!--
        alert("Hello world!");
    //-->
    </script>
    [/code]
    Example Usage
  • VB:
    <script type="text/javascript"> 
    <!-- 
    alert("Hello world!"); 
    //--> 
    </script> 
    
    
    Example Output

PHP Code

The [php] tag performs the same function as the [code] tag, but also adds syntax highlighting for PHP code. Although it is designed for PHP, it may correctly highlight some other C-like languages.

  • [php]value[/php]
    Usage
  • [php]
    $myvar = 'Hello World!';
    for ($i = 0; \$i < 10; \$i++)
    {
        echo $myvar . "\n";
    }
    [/php]
    Example Usage
  • PHP Code:
    $myvar 'Hello World!';
    for (
    $i 0$i 10$i++)
    {
        echo 
    $myvar "\n";

    Example Output

HTML Code

The [html] tag allows you to perform syntax highlighting for HTML code.

  • [html]value[/html]
    Usage
  • [html]
    <img src="image.gif" alt="image" />
    <a href="testing.html" target="_blank">Testing</a>
    [/html]
    Example Usage
  • HTML Code:
    <img src="image.gif" alt="image" />
    <a href="testing.html" target="_blank">Testing</a>
    Example Output

Quote

The [quote] tag allows you to attribute text to someone else.

    • [quote]Quote[/quote]
    • [quote=User Name]value[/quote]
    Usage
    • [quote]Lorem ipsum dolor sit amet[/quote]
    • [quote=John Doe]Lorem ipsum dolor sit amet[/quote]
    • [quote=John Doe;798644]Lorem ipsum dolor sit amet[/quote]
    Example Usage
    • Lorem ipsum dolor sit amet
    • Quote Originally Posted by John Doe
      Lorem ipsum dolor sit amet
    • Quote Originally Posted by John Doe View Post
      Lorem ipsum dolor sit amet
    Example Output

Highlight

The [highlight] tag allows you to emphasize your text.

  • Usage
    [highlight]value[/highlight]
  • Example Usage
    [highlight]this text is highlighted[/highlight]
  • Example Output
    this text is highlighted

Stop BB Code Parsing

The [noparse] tag allows you to stop the parsing of BB code.

  • [noparse][b]value[/b][/noparse]
    Usage
  • [noparse][b]Lorem ipsum dolor sit amet[/b][/noparse]
    Example Usage
  • [b]Lorem ipsum dolor sit amet[/b]
    Example Output

Attachment

The [attach] tag allows you to display an attachment in your post rather than at the bottom. It will only display attachments that belong to the post in which it is utilized.

  • [attach]attachmentid[/attach]
    Usage
  • [attach]12345[/attach]
    Example Usage
  • Example Output

ActiveData

Links to active data add-in

  • [ad]value[/ad]
    Usage
  • [ad]*[/ad]
    Example Usage
  • Example Output

Advanced Filter

Link to Advanced Filters

  • [advf]value[/advf]
    Usage
  • [advf]*[/advf]
    Example Usage
  • AdvancedFilter
    Example Output

AutoFilter

Link to AutoFilters

  • [af]value[/af]
    Usage
  • [af]*[/af]
    Example Usage
  • AutoFilter
    Example Output

Relative & Absolute Referencing

Links to Relative & Absolute Referencing

  • [ar]value[/ar]
    Usage
  • [ar]*[/ar]
    Example Usage
  • Absolute Relative Referencing
    Example Output

Array Formula

Use this at the bottom of your post to insert an N.B. about how to confirm an array formula

  • [arf]value[/arf]
    Usage
  • [arf]*[/arf]
    Example Usage

  • * Array Formulas (sometimes referred to as "CSE" formulas) have to be confirmed by pressing Ctrl+Shift+Enter rather than just pressing Enter
    Example Output

Access Videos

Big Caps

Will change text to big caps.

  • [bc]value[/bc]
    Usage
  • [bc]big caps[/bc]
    Example Usage
  • big caps
    Example Output

Blue Formula

Turns a formula blue.

  • [bf]value[/bf]
    Usage
  • [bf]=SUM(A1:A10)[/bf]
    Example Usage

  • Try this formula. Array formulas will have curly brackets {} emcompassing the ENTIRE formula. You do not add these, you Enter the formula with Ctrl+Shift+Enter and Excel will add them (details: Array formulas). Many more Excel Formulas

    =SUM(A1:A10)
    Example Output

Blue Formula no heading

Turns a formula blue with no heading text

  • [bfn]value[/bfn]
    Usage
  • [bfn]=SUM(A1:A10)[/bfn]
    Example Usage
  • =SUM(A1:A10)
    Example Output

Read Rules

Request questions asker to read rules and adhere to them.

  • [bp]value[/bp]
    Usage
  • [bp]*[/bp]
    Example Usage
  • Please read THIS PAGE IN FULL.
    Example Output

Cell

Adds cells to Grid

  • [cell=Option]value[/cell]
    Usage
  • [cell="your attributes"]Cell 1[/cell]
    Example Usage
  • Cell 1
    Example Output

Conditional Formatting

  • [cf]value[/cf]
    Usage
  • [cf]*[/cf]
    Example Usage
  • Conditional Formatting
    Example Output

Custom Number Formats

Links to Custom Number Formats

  • [cnf]value[/cnf]
    Usage
  • [cnf]*[/cnf]
    Example Usage
  • Custom Formats
    Example Output

Cross Posting

For users who cross post.

  • [cp]value[/cp]
    Usage
  • [cp]*[/cp]
    Example Usage
  • CROSS POST


    This question has been posted in at least one other forum.
    Do not post any further responses in this thread while this post remains.


    Whilst we would rather you didn't cross-post, we know that there may be a valid reason for doing so. All we ask is that you provide the links in your original post to your question in the other forum(s). This is also one of the rules that you agreed to upon joining.

    Ozgrid is full of volunteers that give up their own time to help others, something that should be respected and not taken for granted. Itís never nice for someone to find out that a problem they have spent time solving for you has already been answered somewhere else without them knowing, and so we ask you to make it clear that you have also asked elsewhere.

    Please update your original post to include the link(s).


    Example Output

Linked ComboBox Controls

Links to Linked ComboBox Controls

  • [dcb]value[/dcb]
    Usage
  • [dcb]*[/dcb]
    Example Usage
  • Linked ComboBox Controls
    Example Output

Double Line Break

Adds a double line break.

  • [dl]value[/dl]
    Usage
  • [dl]*[/dl]
    Example Usage


  • Example Output

DON'T LIKE ALL THE ADS?

DON'T LIKE ALL THE ADS?

Don't post

PLEASE DO NOT REPLY TO THIS POST UNTIL THE QUESTION ASKERS HAS AKNOWLEDGED THE TEXT BELOW

  • [DNR]value[/DNR]
    Usage
  • [DNR]*[/DNR]
    Example Usage
  • PLEASE DO NOT REPLY TO THIS POST UNTIL THE QUESTION ASKERS HAS AKNOWLEDGED THE TEXT BELOW
    Example Output

Dynamic named range

Wil convert to a link pointing to the Dynamic Named Range page.

  • [dr]value[/dr]
    Usage
  • [dr]*[/dr]
    Example Usage
  • Dynamic Named Range
    Example Output

Excel Dates & Times

Link to Excel Date & Times

  • [dt]value[/dt]
    Usage
  • [dt]*[/dt]
    Example Usage
  • Excel Dates & Times
    Example Output

Data Validation

  • [dv]value[/dv]
    Usage
  • [dv]*[/dv]
    Example Usage
  • Data Validation
    Example Output

Dependend Validation Lists

Links to Dependend Validation Lists

  • [dvl]value[/dvl]
    Usage
  • [dvl]*[/dvl]
    Example Usage
  • Dependend Validation Lists
    Example Output

Enter Array Formula

How to enter array formulas and a link to their use.

  • [ea]value[/ea]
    Usage
  • [ea]*[/ea]
    Example Usage
  • To Enter the array formula hold down Ctrl and Shift while pushing Enter.
    Example Output

Excel Charts

Links to Excel Chart Tips by Andy Pope

  • [ec]value[/ec]
    Usage
  • [ec]*[/ec]
    Example Usage
  • Excel Charts
    Example Output

Excel Percentages

Links to Excel Percentages

  • [ep]value[/ep]
    Usage
  • [ep]*[/ep]
    Example Usage
  • Percentages
    Example Output

Efficient Spreadsheet Design

Links to Efficient Spreadsheet Design

  • [esd]value[/esd]
    Usage
  • [esd]*[/esd]
    Example Usage
  • Efficient Spreadsheet Design
    Example Output

Excel Table

N/A

  • [et]value[/et]
    Usage
  • [et]SUM(A1:A5)[/et]
    Example Usage
  •   A B C D E F
    1 {Param} {Param} {Param} {Param} {Param} {Param}
    2 {Param} {Param} {Param} {Param} {Param} {Param}
    3 {Param} {Param} {Param} {Param} {Param} {Param}
    4 {Param} {Param} {Param} {Param} {Param} {Param}
    5 {Param} {Param} {Param} {Param} {Param} {Param}
    Example Output

Formula Tag

Formats formula into a cell with row and column headings.

  • [f]value[/f]
    Usage
  • [f]=SUM(A1:A10)[/f]
    Example Usage

  • Try this formula. Column letter & Row number are for example only. Array formulas will have curly brackets {} emcompassing the ENTIRE formula. You do not add these, you Enter the formula with Ctrl+Shift+Enter and Excel will add them (details: Array formulas). Many more Excel Formulas
     Z
    100 =SUM(A1:A10) 

    Example Output

How To Get Questions Answered

How To Get Your Questions Answered....FAST!!

FAQ

Shows drop-down list of Excel frequently asked questions.

  • [faq]value[/faq]
    Usage
  • [faq]*[/faq]
    Example Usage
  • Example Output

Fill Handle

Links to Fill Handle page

  • [fh]value[/fh]
    Usage
  • [fh]*[/fh]
    Example Usage
  • Fill Down With Fill Handle
    Example Output

Find Method

Links to Find Method

  • [fm]value[/fm]
    Usage
  • [fm]*[/fm]
    Example Usage
  • Find Method
    Example Output

Free Questions/Threads

How to get Free Questions/Threads

Forum Rules

Link to forum rules

  • [fr]value[/fr]
    Usage
  • [fr]*[/fr]
    Example Usage
  • PLease read the Rules you agreed to.
    Example Output

Formula Tag No Row/Column

Formats a formula into a cell with no Row or Column headings.

  • [frc]value[/frc]
    Usage
  • [frc]=SUM(A1:A10)[/frc]
    Example Usage

  • Try this formula. Array formulas will have curly brackets {} emcompassing the ENTIRE formula. You do not add these, you Enter the formula with Ctrl+Shift+Enter and Excel will add them (details: Array formulas). Many more Excel Formulas
     
     =SUM(A1:A10) 

    Example Output

Signature Video

GetOpenFileName

Links to GetOpenFileName

  • [gofn]value[/gofn]
    Usage
  • [gofn]*[/gofn]
    Example Usage
  • GetOpenFileName
    Example Output

Grid

Makes a Table

  • [grid=Option]value[/grid]
    Usage
  • [grid="your attributes"]Table content[/grid]
    Example Usage
  • Table content
    Example Output

Google Search

Places a Google search box in the post with the keyword you use.

  • [gs=Option]value[/gs]
    Usage
  • [gs=search keyword]*[/gs]
    Example Usage
  • Try this search: search keyword
    Example Output

Add To Google Toolbar

Adds latest threads to Google Toolbar

Hijack post

Shortcut for "Thread Hijack" response, note that at least one character will need to appear between the [h] and the [/h]

  • [h]value[/h]
    Usage
  • [h]*[/h]
    Example Usage
  • Thread Hijack


    Please do not post any further responses to this thread unless they are in answer to the original post.


    It appears that you have posted your own question in a thread that was started by another user. This is more commonly known as "thread hijacking" and is something that we have stated must not be done as part of the rules that you agreed to upon joining.

    Please start a new thread for your question, and if you feel it would help others to understand the context of your question, you can provide a link back to this thread by copy and pasting the URL in the address bar.

    If this is an old thread, it will now be closed in order to prevent any further responses.

    If you have any questions regarding this request, please feel free to send a PM to any moderator or administrator who will be able to assist further. Thanks in advance for your continued co-operation.

    Example Output

Heading 1

Makes the largest heading

  • [h1]value[/h1]
    Usage
  • [h1]Heading[/h1]
    Example Usage
  • Heading

    Example Output

Heading 2

Makes the second largest heading.

  • [h2]value[/h2]
    Usage
  • [h2]Heading[/h2]
    Example Usage
  • Heading

    Example Output

Heading 3

Makes the third largest heading.

  • [h3]value[/h3]
    Usage
  • [h3]Heading[/h3]
    Example Usage
  • Heading

    Example Output

Heading 4

Makes the fourth largest heading.

  • [h4]value[/h4]
    Usage
  • [h4]Heading[/h4]
    Example Usage
  • Heading

    Example Output

Heading 5

Makes the smallest heading.

  • [h5]value[/h5]
    Usage
  • [h5]Heading[/h5]
    Example Usage
  • Heading
    Example Output

Hijack

To be used for members who post their question in the Thread of another member.

  • [Hijack]value[/Hijack]
    Usage
  • [Hijack]*[/Hijack]
    Example Usage
  • THREAD HIJACK Please read THIS PAGE IN FULL.
    Example Output

Hyperlinks

Links to Hyperlinks

  • [hl]value[/hl]
    Usage
  • [hl]*[/hl]
    Example Usage
  • Hyperlink
    Example Output

Half Price Excel Course

Half Price Excel Course

Solid Line

Adds a solid line.

  • [hr]value[/hr]
    Usage
  • [hr]*[/hr]
    Example Usage

  • Example Output

InputBox

Links to InputBox page

  • [ib]value[/ib]
    Usage
  • [ib]*[/ib]
    Example Usage
  • InputBox
    Example Output

IF Function

Link to IF Function

  • [if]value[/if]
    Usage
  • [if]*[/if]
    Example Usage
  • IF Formula
    Example Output

iframe

Places a web page within a post.

  • [iframe]value[/iframe]
    Usage
  • [iframe]url[/iframe]
    Example Usage
  • url
    Example Output

Justify

Justifies text alignment

  • [j]value[/j]
    Usage
  • [j]This text has been justified so that all lines will finish at the same spot. It does this by spacing out the text with spaces. This can often make the text you type much more readable[/j]
    Example Usage
  • This text has been justified so that all lines will finish at the same spot. It does this by spacing out the text with spaces. This can often make the text you type much more readable
    Example Output

Keyboard Button

  • [kbd]value[/kbd]
    Usage
  • [kbd]Ctrl[/kbd]+[kbd]Alt[/kbd]+[kbd]Del[/kbd]
    Example Usage
  • Ctrl+Alt+Del
    Example Output

Last Cell In Range

Find Last Used Cell In any Range

  • [luc]value[/luc]
    Usage
  • [luc]*[/luc]
    Example Usage
  • Last Used Cell
    Example Output

Lookup With Conditions

Shows links to many lookup functions.

Standard Macro Code

Allows for quick adding of intructions on how to add code to standard module and then run it.

  • [mc]value[/mc]
    Usage
  • [mc]*[/mc]
    Example Usage
  • To add this code to a Module. While in Excel push Alt+F11 and then go to Insert>Module. In here paste the code. Click the top right X to get back to Excel and save. Now push Alt+F8 and select the macro name and click Run
    Example Output

Multi Condition Count

Links to Multi Condition Count

  • [mcc]value[/mcc]
    Usage
  • [mcc]*[/mcc]
    Example Usage
  • Multiple Criteria Counting
    Example Output

Multi Condition Sum

Link to Multi Condition Summing

  • [mcs]value[/mcs]
    Usage
  • [mcs]*[/mcs]
    Example Usage
  • Multiple Criteria SUM
    Example Output

No Code Tags

  • [nct]value[/nct]
    Usage
  • [nct]*[/ntc]
    Example Usage
  • [nct]*[/ntc]
    Example Output

Number 1 Mistake By Excel Spreadsheet Users

Links to Number 1 Mistake By Excel Spreadsheet Users

Named Ranges

Link to named ranges.

  • [nr]value[/nr]
    Usage
  • [nr]*[/nr]
    Example Usage
  • Named Ranges
    Example Output

Free Training

Free help for Excel newbies

  • [nt]value[/nt]
    Usage
  • [nt]*[/nt]
    Example Usage
  • Ozgrid has some Free Excel Level 1 Training that will help you get a better grasp on Excel.
    Example Output

Overline

Will place a overline above the text

  • [ol]value[/ol]
    Usage
  • [ol]some text to overline[/ol]
    Example Usage
  • some text to overline
    Example Output

Excel Object Model

Links to all of Excel Objects

Run Macros On Time

Links to OnTime Method Page

  • [otm]value[/otm]
    Usage
  • [otm]*[/otm]
    Example Usage
  • Run Macros At Set Dates & Times
    Example Output

Proper Case

Will captilize the first letter of each word.

  • [pc]value[/pc]
    Usage
  • [pc]all in lower case[/pc]
    Example Usage
  • all in lower case
    Example Output

Pivot Table

Will create a link pointing to the Pivot Table page.

  • [pt]value[/pt]
    Usage
  • [pt]*[/pt]
    Example Usage
  • Pivot Tables
    Example Output

PowerPoint Videos

Related Data Validation Pages

Content pages related to data validation

Record a Macro

Links to Record a Macro

  • [rm]value[/rm]
    Usage
  • [rm]*[/rm]
    Example Usage
  • Record a Macro
    Example Output

Run Macros On Protected Sheets

Link to Run Macros On Protected Sheets

  • [rmonps]value[/rmonps]
    Usage
  • [rmonps]*[/rmonps]
    Example Usage
  • Run Macros On Protected Sheets
    Example Output

Row

Adds Row to Grid

  • [row]value[/row]
    Usage
  • [row]Cell Rows[/row]
    Example Usage
  • Cell Rows
    Example Output

Strikethrough

Will place a strike through the center of text

  • [s]value[/s]
    Usage
  • [s]Stike through text[/s]
    Example Usage
  • Stike through text
    Example Output

Small Caps

Will change text to small capitals.

  • [sc]value[/sc]
    Usage
  • [sc]small caps[/sc]
    Example Usage
  • small caps
    Example Output

SpecialCells Method

Link the SpecialCells Method

  • [scm]value[/scm]
    Usage
  • [scm]*[/scm]
    Example Usage
  • SpecialCells
    Example Output

Sheet Code Name

Links to How to Reference Excel Sheets

  • [scn]value[/scn]
    Usage
  • [scn]*[/scn]
    Example Usage
  • Sheet Code Names
    Example Output

Select Case

Links to Select Case Statement

  • [scs]value[/scs]
    Usage
  • [scs]*[/scs]
    Example Usage
  • Select Case Statement
    Example Output

SUM Function

Links to SUM Formula page

  • [sf]value[/sf]
    Usage
  • [sf]*[/sf]
    Example Usage
  • SUM Formula
    Example Output

Table Poster

Links to shg (OzMVP) add-in to allowing copy/paste direct from Excel to forum posts.

Subscibed Links

Adds Google subscribed links button

  • [sl]value[/sl]
    Usage
  • [sl]*[/sl]
    Example Usage
  • Example Output

NewThread

Start new thread

SS

Retains spacing

  • [ss=Option]value[/ss]
    Usage
  • [ss="Some Spaced Out Text"]*[/ss]
    Example Usage
  • CREATE TABLES LIKE BELOW?
    Some            Spaced Out         Text
    Example Output

Scroll Text

Will cause text to scroll from left to right.

  • [st]value[/st]
    Usage
  • [st]Scrolling Text[/st]
    Example Usage
  • Scrolling Text
    Example Output

Subscript

Will drop text below the line.

  • [sub]value[/sub]
    Usage
  • <sub>Drop</sub> below line
    Example Usage
  • <sub>Drop</sub> below line
    Example Output

Superscipt

Will place text above the line.

  • [sup]value[/sup]
    Usage
  • [sup]Raise[/sup] above line
    Example Usage
  • Raise above line
    Example Output

Post a Sample Workbook

Describes how to add a sample workbook.

  • [sw]value[/sw]
    Usage
  • [sw]*[/sw]
    Example Usage
  • How to Attach a Sample Workbook

    To attach a workbook:

    1. Click 'Go Advanced' at the bottom right of the Reply Box.
    2. In the new window click the Paper Clip Icon.
    3. In the new window that pops up click 'Add Files'.
    4. Click 'Select File' and browse to the required file.
    5. Click 'Upload File'.
    6. Click 'Done' when the selected file appears in the box at the bottom of the window.

    The maximum file size allowed is 3MB, if your file is larger than this you can try zipping it to reduce the size. If still too large, or if your actual file contains sensitive data, then create a sample workbook with reduced amount of data or with sanitised data.

    When creating a sample workbook it is essential that the structure of the actual workbook is retained.
    • If data has been sanitised, then the sanitised data must be of the same type as the original (text still text, numbers still numbers, dates still dates etc.).
    • The Layout of data on each sheet remains the same.
    • If actual data contains blank rows, columns or cells then include the same in the sample data.
    • If a cell contains a formula keep the formula in the sample, in other words do not create the sample file by pasting just values from the actual file.

    An accurate sample workbook will help us to help you.

    Example Output

Track Changes Code

Links to Track Changes Code

  • [tc]value[/tc]
    Usage
  • [tc]*[/tc]
    Example Usage
  • Track Changes Code
    Example Output

Poor Thread Title

For members who use poor New Thread Titles.

  • [Thread Title]value[/Thread Title]
    Usage
  • [Thread Title]*[/Thread Title]
    Example Usage
  • POOR THREAD TITLE Please read THIS PAGE IN FULL
    Example Output

Toggle

Hide/Shows text

  • [toggle]value[/toggle]
    Usage
  • [toggle]Hide/Show Text[/toggle]
    Example Usage
  • Example Output

Poor Thread Title

Informs users of poor Thread Titles

  • [tt]value[/tt]
    Usage
  • [tt]*[/tt]
    Example Usage
  • POOR THREAD TITLE Please read THIS PAGE IN FULL
    Example Output

Custom Functions

Link to Custom Functions

  • [udf]value[/udf]
    Usage
  • [udf]*[/udf]
    Example Usage
  • User Defined Function
    Example Output

Unformatted Code

Applies PRE and CODE tags to the selected text, but doesn't apply any syntax highlighting.

  • [ufcode]value[/ufcode]
    Usage
  • [ufcode]some code here[/ufcode]
    Example Usage
  • some code here
    Example Output

VBA Variables

Links to VBA Variables

  • [v]value[/v]
    Usage
  • [v]*[/v]
    Example Usage
  • Variables
    Example Output

VLOOKUP

Links to VLOOKUP page

  • [vl]value[/vl]
    Usage
  • [vl]*[/vl]
    Example Usage
  • VLOOKUP
    Example Output

Vlookup

Point users to VLOOKUP, INDEX and MATCH

  • [vlookup]value[/vlookup]
    Usage
  • [vlookup]*[/vlookup]
    Example Usage
  • See VLOOKUP and/or INDEX/MATCH
    Example Output

Workbook Module Code

Allows for quick adding of intructions on how to add code to the Private Module of the Workbook object.

  • [wbc]value[/wbc]
    Usage
  • [wbc]*[/wbc]
    Example Usage
  • Open the VBE (Alt+F11) and then double click "ThisWorkbook" in the Project Explorer. This is where the code MUST be placed.
    Example Output

Worksheet Change Event

Link to Worksheet Change Event

  • [wce]value[/wce]
    Usage
  • [wce]*[/wce]
    Example Usage
  • Worksheet Change Event
    Example Output

Workbook Open Event

Link to Workbook Open Event

  • [woe]value[/woe]
    Usage
  • [woe]*[/woe]
    Example Usage
  • Workbook Open Event
    Example Output

Worksheet Module Code

Allows for quick adding of intructions on how to add code to the Private Module of the Worksheet object.

  • [wsc]value[/wsc]
    Usage
  • [wsc]*[/wsc]
    Example Usage
  • Open the VBE (Alt+F11) and then double click the Sheet in the Project Explorer the code applies to. This is where the code MUST be placed.
    Example Output

Spreadsheet

Adds a Web Spreadsheet Component

porno