Announcement

Collapse
No announcement yet.

Custom BB Code Tests

Collapse
This topic is closed.
X
This is a sticky topic.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Dave Hawley
    started a topic Custom BB Code Tests

    Custom BB Code Tests

    Horizontal Line


    Heading 1

    Heading Here


    Heading 2

    Heading Here


    Heading 3

    Heading Here


    Heading 4

    Heading Here


    Heading 5
    Heading Here

    Justified Text

    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


    Blinking Text

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

    Overline

    Some overlined text

    Strikethrough
    Strike through text

    Text above line
    raise above line

    Text below line
    Drop below line

    Small Caps
    typed in lower case

    Big Caps
    typed in lower case

    Proper Case
    will change the first letter of each word to a capital

    Scrolling Text
    Some scolling text

    Quick Instructions On How to Add Code to a Sheet Object
    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.

    Quick Instructions On How to Add Code to a Workbook Object
    Open the VBE (Alt+F11) and then double click "ThisWorkbook" in the Project Explorer. This is where the code MUST be placed.

    Quick Instructions On How to Add Code to a Standard Module and Run it.
    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

  • pike
    replied
    Re: Custom BB Code Tests

    BJL

    This is the test form please post your question in the excel help forum

    Leave a comment:


  • BJL
    replied
    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.

    Sales Order #
    Contract # Start Date End Date Sales Order #
    Sales Order Date
    6101479214 54027626 7/13/2011 12/18/2019 6101479214 7/13/2011
    6101485835 54952166 11/9/2011 12/30/2019 6101485835 11/9/2011
    6101486137 55073527 11/23/2011 10/29/2020 6101486137 11/23/2011
    6101486679
    55206820 12/7/2011 12/5/2019 6101486679 12/7/2011
    6101486679
    55187822 12/7/2011 12/5/2019 6101487377
    12/6/2011
    6101487377
    55189203 12/6/2011 12/4/2019 6101487648 12/30/2011
    6101487377 55174785 12/5/2011 12/4/2019 6101487703 12/15/2011
    6101487648 55428788 12/30/2011 1/3/2020 6101488006 12/12/2011
    6101487703 55272346 12/15/2011 12/13/2019 6101488109 1/10/2012

    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)


    Sales Order #
    Contract # Start Date End Date Sales Order #
    Sales Order Date
    6300740128
    52591614 3/4/2013
    3/3/2021 6300740128 12/10/2010




    6300740128 12/11/2010
    6300751301 52747989 12/6/2011 3/13/2016 6300751301 12/30/2010
    6300753393 52747068 12/30/2010 5/15/2021 6300753393 12/30/2010




    6300753393 12/30/2010




    6300753393 12/30/2010
    6300759135
    52827765 1/13/2011 7/28/2021 6300759135 1/13/2011
    6300759135 52814196 1/13/2011 5/19/2021

    6300759408 52780811 1/7/2011 12/7/2019 6300759408 1/7/2011
    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/madrocket...ine-up-matches

    Code:
    Option Explicit
    
    Sub LineEmUp3()
    'Author:    Jerry Beaucaire
    'Date:      10/27/2010
    'Summary:   Align codes in columns C and D removing all D values not in C
    Dim i As Long, LR As Long
    Application.ScreenUpdating = False
    
    'Last row with data in column F
        LR = Range("F" & Rows.Count).End(xlUp).Row
    
    'Sort both section so numbers are ascending in E and F
        Columns("A:E").Sort Key1:=Range("E2"), Order1:=xlAscending, _
            Header:=xlYes, OrderCustom:=1, MatchCase:=False, _
            Orientation:=xlTopToBottom, DataOption1:=xlSortNormal
        Columns("F:H").Sort Key1:=Range("F2"), Order1:=xlAscending, _
            Header:=xlYes, OrderCustom:=1, MatchCase:=False, _
            Orientation:=xlTopToBottom, DataOption1:=xlSortNormal
    
    'line up remaining items so F lines up with E
        i = 2
        Do
            If Cells(i, "E") > Cells(i, "F") And Cells(i, "F") > "" Then
                Cells(i, "A").Resize(1, 5).Insert xlShiftDown
            ElseIf Cells(i, "E") < Cells(i, "F") And Cells(i, "E") > "" Then
                Cells(i, "F").Resize(1, 3).Insert xlShiftDown
            End If
            i = i + 1
        Loop Until Cells(i, "E") = "" And Cells(i, "F") = ""
    
    Application.ScreenUpdating = True
    End Sub
    

    Leave a comment:


  • pike
    replied
    Re: Custom BB Code Tests

    A B C
    1 Apple Lemon Guava
    2 Orange Mango Cherry
    3 Banana Kiwi Litchi

    Leave a comment:


  • pike
    replied
    Re: Custom BB Code Tests

    A B C D
    1 a1 b1 c1 d1
    2 a2 b2 c2 d2
    3 a3 b3 c3 d3
    4 a4 b4 c4 d4

    Leave a comment:


  • Simon Lloyd
    replied
    Re: Custom BB Code Tests

    Test post Here!

    Leave a comment:


  • Simon Lloyd
    replied
    Re: Custom BB Code Tests

    test post http://www.ozgrid.com/forum/showpost.php?p=285681&postcount=1

    Leave a comment:


  • max_lux
    replied
    Re: Custom BB Code Tests

    test

    Welcome to OzGrid Forums!

    EDIT -- jiuk

    Please take more care in future, and good luck with your post!
    Last edited by Jack in the UK; March 4th, 2006, 08:12.

    Leave a comment:


  • Will Riley
    replied
    Re: What BB Code was used less the '

    Ha Ha ... funny guy

    Leave a comment:


  • Dave Hawley
    replied
    Re: What BB Code was used less the '

    Sorry, I will read the rules

    Leave a comment:


  • Will Riley
    replied
    Re: What BB Code was used less the '

    testing bp code tags

    Please read THIS PAGE IN FULL.

    Leave a comment:


  • Dave Hawley
    replied
    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
    typed in lower case

    Big Caps
    typed in lower case

    Proper Case
    will change the first letter of each word to a capital

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

    Quick Instructions On How to Add Code to a Sheet Object
    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.

    Quick Instructions On How to Add Code to a Workbook Object
    Open the VBE (Alt+F11) and then double click "ThisWorkbook" in the Project Explorer. This is where the code MUST be placed.

    Quick Instructions On How to Add Code to a Standard Module and Run it.
    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
    Last edited by royUK; September 28th, 2005, 17:05.

    Leave a comment:

Working...
X