+ Reply to Thread
Results 1 to 3 of 3

excel functions similar/the same as VBA functions

  1. #1
    Forum Contributor FRIEL's Avatar
    Join Date
    03-07-2008
    Location
    Coventry
    MS-Off Ver
    2003 and 2007
    Posts
    266

    excel functions similar/the same as VBA functions

    i have come across a couple of times instances where there is a VBA function that does the same job as a function in excel

    like
    ASC
    does tthe same as CHAR but it does it in VBA before going on to the sheet
    my Question is
    is there a way to get a list of ALL of the functions like this that exist in VBA???

    also posted here
    I dont like to use code i dont understand
    it makes it hard to use in other situations
    so please try to be as clear and patent as possible with me

    Criticism is welcomed

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Use the Object Browser and type in worksheetfunction
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Contributor FRIEL's Avatar
    Join Date
    03-07-2008
    Location
    Coventry
    MS-Off Ver
    2003 and 2007
    Posts
    266

    Thumbs up

    ah thanks roy got it
    didnt know that you needed to type
    Please Login or Register  to view this content.
    before
    thanks
    friel

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1