Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    v-messer
    @v-messer
    Hello world! This community is created for every one, who works, studies and just having fun with VBA for MS Office. Feel free to write and invite your friends!
    Since we have a very little community, please don't leave this chat - join it! And one day it should grow enough!
    InternetUnexplorer
    @InternetUnexplorer
    Hey there!
    I don't use VBA at all, but I saw your message in gitterHQ/developers and decided to stop by and say hi.
    v-messer
    @v-messer
    Very welcome, IU👍
    You totally unexplored us.
    InternetUnexplorer
    @InternetUnexplorer
    Sounds nifty. I like it.
    v-messer
    @v-messer
    @shankyty Welcome here!
    @shankyty How long you in VBA?
    Scott Spence
    @spences10
    Hello world
    Any guys here use VBA with source code control [vcs]??
    Ben
    @Arico1985
    Hey guys, i am using basic VBA and am stuck on a command, any chance someone coul dhelp ?
    DreCurrency
    @drecurrency
    Hello
    Can someone help on how i look up whether a value is contained in multiple sheets and which sheet that value is contained in ?
    Done some vlookups but does not tell me what sheets it comes from
    PunitGoel
    @PunitGoel
    Hi world
    I am ndw new to this group
    Scott Spence
    @spences10
    @drecurrency I'm guessing you sorted this now?
    Karthi Keyan
    @mskarthi95
    improve the community of vba
    vba in wxcel, access and powerpoint
    why we do macro automation
    APMLover
    @APMLover
    Hi
    Im very interested in VBA
    v-messer
    @v-messer
    @APMLover Glad to See you here!
    parthi2929
    @parthi2929
    I am getting an automation/unspecified error while trying to write a code to parse JSON. Kindly check the link below and help
    VBA-tools/VBA-JSON#83
    v-messer
    @v-messer
    Tip of the day!
    Use Application.ScreenUpdating = False
    at the begin of macro and
    Use Application.ScreenUpdating = True
    at the end to improve macro speed
    q
    Tip of the day!
    Use Application.ScreenUpdating = False
    at the begin of macro and
    Use Application.ScreenUpdating = True
    at the end to improve macro speed
    Tip of the day! Use Application.ScreenUpdating = False at the begin of macro and
    Use Application.ScreenUpdating = True at the end to improve macro speed
    Riek Rudolph
    @RiekRudolph_twitter
    Hi There! Anyone here familiar with word-VBA?
    APMLover
    @APMLover
    Im not familiar with that, but I like work vba. nice to meet you
    I made several simple programs with word vba.
    Riek Rudolph
    @RiekRudolph_twitter
    Nice! Could u have a brief look at my problem here? https://stackoverflow.com/questions/51080855/vba-range-text-writes-into-cell-without-actually-writing-in Would be awesome
    Josebuendia
    @Josebuendia
    Hi, please

    Private Sub cmdshowChart_Click()

        Dim S, e, cm, inches As Double
    
            S = CDbl(txtStart.Text)
            e = CDbl(txtEnd.Text)
    
            cm = S 'initialiser
            While cm <= e 'guard
                inches = cm / 2.54
                txtConversionChart.AddItem (cm & " cms = " & inches & "inches")
                'advancer
                cm = cm + 1
                Wend

    End Sub

    Why is'nt this code creating a chart cm to inches?
    How do you put programs created in ms VBA into normal excel?
    prog20901
    @prog20901

    Save the word as text file after applying font with UTF-8

    i have a word file which shows boxes when i opened. However when choosing a particular font, the text is being displayed. I selected all the content of the document with ctr+a and changed the font and save as .txt file with UTF-8.

    Everything works fine.

    Is there is any macro can do this automatically? Basically applying a font for entire document and save as .txt file with UTF-8?

    Any tool or software does this?

    prog20901
    @prog20901

    When i declare a column as varchar(2) - assume my input is ab - only 2 characters are allowed. When i try to insert one more character it throws error.

    When i declare a column as varchar(4) - assume my input is abcd - only 4 characters are allowed. When i try to insert one more character it throws error.

    When i declare a column as varchar(255) - however i can able to input abcdabcdabcd...more than 255 characters

    I don't understand how many alphabetical small case characters a varchar(255) can hold. if it can hold many...why the same is not applicable for varchar(2) or varchar(4)