Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

VBA coding - where to find helpful methods?

Options
  • 10-11-2008 3:16pm
    #1
    Peter B
    Registered Users Posts: 1,086 ✭✭✭


    I am fairly new to VBA. I am using it for creating macros with Microsoft Excel. I have been working with PHP for a while now and love the easy
    access to lots of different methods already built in to PHP.



    For example I am working a lot with dates in the task I am doing now. One thing that bugs me is that I cannot find a simple function to
    convert and display dates in different ways. I have been googling for
    ages and finally found out how to display a month name using a function taking the month number as a parameter. I want to find more ways to
    change the look of dates easily. eg from "01/10/2008" to "October, the
    1st 2008"

    Also I want to be able to display a number with its suffix automatically chosen such as "31st", "2nd", "3rd", or "10th". I know I can create this
    function quickly and easily but would ideally like to know are these
    functions out there in VBA and if they are where could I find them.

    Thanks


Advertisement