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

  • 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

  • #2
    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.

    Comment


    • #3
      Re: What BB Code was used less the '

      testing bp code tags

      Please read THIS PAGE IN FULL.
      Kind Regards, Will Riley

      LinkedIn: Will Riley

      Comment


      • #4
        Re: What BB Code was used less the '

        Sorry, I will read the rules

        Comment


        • #5
          Re: What BB Code was used less the '

          Ha Ha ... funny guy
          Kind Regards, Will Riley

          LinkedIn: Will Riley

          Comment


          • #6
            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.
            I LOVE Spam please use my email for all spam: [email protected]

            Comment


            • #7
              Re: Custom BB Code Tests

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

              In the unlikely event you don't get an answer here try Microsoft Office Help for FREE!
              Please take the time to read these rules before posting!

              Comment


              • #8
                Re: Custom BB Code Tests

                Test post Here!
                Regards,
                Simon

                In the unlikely event you don't get an answer here try Microsoft Office Help for FREE!
                Please take the time to read these rules before posting!

                Comment


                • #9
                  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
                  If the solution helped please donate to RSPCA

                  Sites worth visiting: Rabbitohs | Excel-it royUK | Excel Matters Rory | Kris' Spreadsheet Solutions | Domenic xl-central | SO The Macro Man | The Smallman

                  Comment


                  • #10
                    Re: Custom BB Code Tests

                    A B C
                    1 Apple Lemon Guava
                    2 Orange Mango Cherry
                    3 Banana Kiwi Litchi
                    If the solution helped please donate to RSPCA

                    Sites worth visiting: Rabbitohs | Excel-it royUK | Excel Matters Rory | Kris' Spreadsheet Solutions | Domenic xl-central | SO The Macro Man | The Smallman

                    Comment


                    • #11
                      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
                      

                      Comment


                      • #12


                        Re: Custom BB Code Tests

                        BJL

                        This is the test form please post your question in the excel help forum
                        If the solution helped please donate to RSPCA

                        Sites worth visiting: Rabbitohs | Excel-it royUK | Excel Matters Rory | Kris' Spreadsheet Solutions | Domenic xl-central | SO The Macro Man | The Smallman

                        Comment

                        Working...
                        X