Consulting

Results 1 to 3 of 3

Thread: Just tesitng, checkin out and messin with the BBCodes and stuff

  1. #1
    VBAX Newbie DocAElstein's Avatar
    Joined
    Oct 2023
    Location
    Hof, Germany
    Posts
    4
    Location

    Just tesitng, checkin out and messin with the BBCodes and stuff

    Just testing, checkin out and messin with the BBCodes and stuff to get familiar before "posting for real"


    [size=2][Table]
    [tr=bgcolor:red][td=bgcolor:#blue]Hi vbaexpress[/td][/tr]
    [/table][/size]


    Hi vbaexpress






    _____ Workbook: Mappe1 ( Using Excel 2010 32 bit )
    Row\Col
    A
    B
    1
    2
    Worksheet: Tabelle1

    Sub ShowRangeToBBCForm() 'Main Program
        ufRangeToBBC.Show vbModeless
    End Sub
                                                                                                                                                                     
                                                                                                                       Have I got a horizontal scroll bar  , well it would appear so Alan
    [size=1][Table]
    [tr][td=bgcolor:lightblue][COLOR="#FFFFFF"] [size=2]hallo[/size]
    [/COLOR][/td][/tr][/table][/size]



    hallo
    Last edited by DocAElstein; 10-12-2023 at 02:29 AM.

  2. #2
    VBAX Newbie DocAElstein's Avatar
    Joined
    Oct 2023
    Location
    Hof, Germany
    Posts
    4
    Location
    Quote Originally Posted by DocAElstein View Post
    Just testing, checkin out and messin with the BBCodes and stuff to get familiar before "posting for real"
    http://www.vbaexpress.com/
    http://www.vbaexpress.com/forum/show...l=1#post421358
    http://www.vbaexpress.com/forum/show...uff#post421358

    https://i.postimg.cc/QdtTyfHM/TestPic.jpgName:  TestPic.JPG
Views: 269
Size:  51.3 KB

    Bum titty bum
    https://i.postimg.cc/QdtTyfHM/TestPic.jpgName:  TestPic.JPG
    Views: 269
    Size:  51.3 KB
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .

    Quote Originally Posted by Som View Post
    Open file with vba based on file name
    ….I know how to open a file based on a name …
    Quote Originally Posted by Som View Post
    I would like to open a file, when the filename includes either "cp4" or "gt4"
    Then I have tó open a file, if the filename doesn’t include "ghl"
    Hi,



    Sub SomNames()   '    www.vbaexpress.com/forum/showthread.php?70999-Open-file-with-vba-based-on-file-name
    Dim arrNms() As Variant
     Let arrNms() = Array("abcd.xls", "abcp4cd.xlsm", "abgt4cd.xlsx", "abghlcd.xls", "efgh.xls")
    Dim SomName As Variant
        For Each SomName In arrNms()
            Select Case True
             Case SomName Like "*cp4*"
              MsgBox prompt:="Name  """ & SomName & """  got  ""cp4""  in it"
             Case SomName Like "*gt4*"
              MsgBox prompt:="Name  """ & SomName & """  got  ""gt4""  in it"
            End Select
        Next SomName
        For Each SomName In arrNms()
            Select Case False
             Case SomName Like "*ghl*"
              MsgBox prompt:="Name  """ & SomName & """  not got  ""ghl""  in it"
            End Select
        Next SomName
    End Sub
    Last edited by DocAElstein; 10-12-2023 at 03:22 AM.

  3. #3
    VBAX Newbie DocAElstein's Avatar
    Joined
    Oct 2023
    Location
    Hof, Germany
    Posts
    4
    Location
    Some extra notes for this main forum Thread
    http://www.vbaexpress.com/forum/show...-the-clipboard

    So, just now I am using the forum editer to prepare this post in the usual way. I do something else, somewhere else.
    Then I come back here and I hit the keys Ctrl+V on my keybord and get this

    MR. Lucas Moore
    MISS. Charlotte Johnson
    DR. Oliver Martinez
    PROF. Evelyn Rodriguez
    UNDER. Daniel Wright
    SECRE. Joshua Thompson
    PRE. Logan Howard
    MR. Jacob Robinson
    MISS. Amelia Clark
    DR. Mason Evans
    PROF. Hannah King
    UNDER. Jayden Lee
    SECRE. Christopher Morris
    PRE. Sebastian Young
    MR. Elijah Gonzales
    MISS. Isabella Lopez
    DR. James Wilson
    PROF. Sarah Adams
    UNDER. Gabriel Miller
    SECRE. Matthew Garcia
    PRE. Dylan Ward
    MR. Owen Phillips
    MISS. Mila Simmons
    DR. Henry Allen
    PROF. Camila Stewart
    UNDER. Michael Campbell
    SECRE. Julian Anderson
    PRE. Levi Bell
    MR. Carter Thompson
    MISS. Victoria Martin
    DR. Luke Perez
    PROF. Zoe Torres
    UNDER. Connor Lewis
    SECRE. Isaac Evans
    PRE. Wyatt Morris
    MR. Hunter Ward
    MISS. Audrey Murphy
    DR. Maverick Howard
    PROF. Iris Cooper
    UNDER. Thomas Russell
    SECRE. Caleb Young
    PRE. Sebastian Flores
    MR. Levi Allen
    MISS. Gianna Griffin
    DR. Colton Henderson
    PROF. Eleanor Cook
    UNDER. Hunter Diaz
    SECRE. Xavier Rodriguez
    PRE. Carter James
    SECRETARY



    I bet everyone would like to know how I did that amazing thing. No? Well I am going tp tell ya anyways,
    see here, wot I just posted http://www.vbaexpress.com/forum/show...l=1#post421372 - scroll down to the bit titled
    This is how I did it.
    Last edited by DocAElstein; 10-12-2023 at 08:54 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •