Custom BB Code Tests

  • Horizontal Line
    [HR]*[/HR]
    Heading 1
    [H1]Heading Here[/H1]
    Heading 2
    [H2]Heading Here[/H2]
    Heading 3
    [H3]Heading Here[/H3]
    Heading 4
    [H4]Heading Here[/H4]
    Heading 5
    [H5]Heading Here[/H5]
    Justified Text


    [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]


    Blinking Text


    [blink]Blink[/blink] doesn't blinking work!


    Overline


    [ol]Some overlined text[/ol]


    Strikethrough
    Strike through text


    Text above line
    raise above line


    Text below line
    Drop below line


    Small Caps
    [sc]typed in lower case[/sc]


    Big Caps
    [bc]typed in lower case[/bc]


    Proper Case
    [pc]will change the first letter of each word to a capital[/pc]


    Scrolling Text
    [st]Some scolling text[/st]


    Quick Instructions On How to Add Code to a Sheet Object
    [wsc]*[/wsc]


    Quick Instructions On How to Add Code to a Workbook Object
    [wbc]*[/wbc]


    Quick Instructions On How to Add Code to a Standard Module and Run it.
    [mc]*[/mc]

  • What BB Code was used less the '


    Horizontal Line
    ['HR]*[/HR]
    ['I]Heading 1[/I]
    ['H1]Heading Here[/H1]
    ['I]Heading 2[/I]
    ['H2]Heading Here[/H2]
    ['I]Heading 3[/I]
    ['H3]Heading Here[/H3]
    ['I]Heading 4[/I]
    ['H4]Heading Here[/H4]
    ['I]Heading 5[/I]
    ['H5]Heading Here[/H5]
    ['I]Justified Text[/I]


    ['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]


    ['I]Blinking Text[/I]


    ['blink]Blink[/blink] doesn't blinking work!


    ['I]Overline[/I]


    ['ol]Some overlined text[/ol]


    ['I]Strikethrough[/I]
    ['s]Strike through text[/s]


    ['I]Text above line[/I]
    raise above line


    ['I]Text below line[/I]
    Drop below line


    Small Caps
    [sc]typed in lower case[/sc]


    Big Caps
    [bc]typed in lower case[/bc]


    Proper Case
    [pc]will change the first letter of each word to a capital[/pc]


    Scrolling Text
    ['st]Some scolling text[/st]


    Quick Instructions On How to Add Code to a Sheet Object
    [wsc]*[/wsc]


    Quick Instructions On How to Add Code to a Workbook Object
    [wbc]*[/wbc]


    Quick Instructions On How to Add Code to a Standard Module and Run it.
    [mc]*[/mc]

  • Re: Custom BB Code Tests


    [TABLE="class: grid, width: 200"]

    [tr]


    [td][/td]


    [td]

    A

    [/td]


    [td]

    B

    [/td]


    [td]

    C

    [/td]


    [td]

    D

    [/td]


    [/tr]


    [tr]


    [td]

    1

    [/td]


    [td]

    a1

    [/td]


    [td]

    b1

    [/td]


    [td]

    c1

    [/td]


    [td]

    d1

    [/td]


    [/tr]


    [tr]


    [td]

    2

    [/td]


    [td]

    a2

    [/td]


    [td]

    b2

    [/td]


    [td]

    c2

    [/td]


    [td]

    d2

    [/td]


    [/tr]


    [tr]


    [td]

    3

    [/td]


    [td]

    a3

    [/td]


    [td]

    b3

    [/td]


    [td]

    c3

    [/td]


    [td]

    d3

    [/td]


    [/tr]


    [tr]


    [td]

    4

    [/td]


    [td]

    a4

    [/td]


    [td]

    b4

    [/td]


    [td]

    c4

    [/td]


    [td]

    d4

    [/td]


    [/tr]


    [/TABLE]

  • Re: Custom BB Code Tests


    [TABLE="width: 192"]

    [tr]


    [TD="class: xl74, width: 64, bgcolor: transparent"] [/TD]
    [TD="class: xl73, width: 64, bgcolor: #bfbfbf"]A[/TD]
    [TD="class: xl73, width: 64, bgcolor: #bfbfbf"]B[/TD]
    [TD="class: xl73, width: 64, bgcolor: #bfbfbf"]C[/TD]

    [/tr]


    [tr]


    [TD="class: xl73, bgcolor: #bfbfbf"]1[/TD]
    [TD="class: xl69, bgcolor: #b7dee8"]Apple[/TD]
    [TD="class: xl72, bgcolor: #fcd5b4"]Lemon[/TD]
    [TD="class: xl69, bgcolor: #b7dee8"]Guava[/TD]

    [/tr]


    [tr]


    [TD="class: xl73, bgcolor: #bfbfbf"]2[/TD]
    [TD="class: xl70, bgcolor: #d8e4bc"]Orange[/TD]
    [TD="class: xl72, bgcolor: #fcd5b4"]Mango[/TD]
    [TD="class: xl70, bgcolor: #d8e4bc"]Cherry[/TD]

    [/tr]


    [tr]


    [TD="class: xl73, bgcolor: #bfbfbf"]3[/TD]
    [TD="class: xl71, bgcolor: #ffff99"]Banana[/TD]
    [TD="class: xl72, bgcolor: #fcd5b4"]Kiwi[/TD]
    [TD="class: xl71, bgcolor: #ffff99"]Litchi[/TD]

    [/tr]


    [/TABLE]

  • Re: Custom BB Code Tests


    Here's the basic scrubbed data. For this example, I underlined the matching Sales Orders that should be aligned, and after that, the dates (in bold below) need to be aligned...which is a problem because the dates - even for the same sales order # - can be different.




    So, this is as far as I've gotten. The Sales Orders are aligned as I like (underlined below), but I need to do the same with the corresponding dates (in bold) cause sometimes the dates match, sometimes they don't. Since there are multiple dates, I'm wondering if there's a way to do the True/False comparison. Normally that would be easy, but the blanks (which are still ok) make that harder.


    (Below, I'm using a different chunk of Sales orders than I used above to hopefully make my point clearer)



    Below, is my source for where I'm currently at. Not sure if it's the right approach for what I currently need, though...

    https://sites.google.com/a/mad…functions/line-up-matches