Consulting

Results 1 to 7 of 7

Thread: List of Functions in Excel VBA

  1. #1

    List of Functions in Excel VBA

    Hi all

    Is it possible to run a VBA code to produce a list of funtions from excel?

    I.E : =sum(number1,number2...)


    Thanks

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Probably not. Why woud you need it?
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    I would like a list of them for training purposes, i have seen a VBA code that can be run to give you error number, thought there might be one for formulas...

  4. #4
    Mac Moderator VBAX Guru mikerickson's Avatar
    Joined
    May 2007
    Location
    Davis CA
    Posts
    2,778
    A list of all the spreadsheet functions, with links to the help system, can be found by selecting an empty cell and using Insert Function.

  5. #5
    i am aware of that, i am looking for a prntable version

  6. #6
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Peter Noneley created one http://www.xlfdic.com/
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  7. #7
    xld, once again you have proven your worth!!!! thanks

Posting Permissions

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