Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Page 1 of 2 1 2 LastLast
Results 1 to 10 of 12

Thread: vba functions list

  1. #1
    Join Date
    2nd December 2004
    Posts
    44

    vba functions list

    This is a great site. Anyone know of a place where i can obtain a list of excel and/or vba functions and their respective actions? trying to understand the "how" and "why" of written programs and a reference list would be very helpful. I've searched google (this is how i found this site) and no luck.

    Thanks in advance.

    alan

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    6th September 2004
    Posts
    438

    Re: vba functions list

    Have you tried the Excel help files?

    TJ
    Oh dear I need a beer
    Online Motorsport Game

  3. #3
    Join Date
    17th July 2004
    Location
    Texas, USA
    Posts
    1,939

    Re: vba functions list

    For xl worksheet functions go to xl help and select keyword function

    For available xl functions in VBA go to VBA help and select keyword functions then select "list of worksheet functions available to Visual Basic"

    hope this helps

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    17th July 2004
    Location
    Texas, USA
    Posts
    1,939

    Re: vba functions list

    An excellent source for Objects, Properties and Methods is the appendix in:

    Excel 2003 VBA Programmer's Reference
    by Paul T. Kimmel, Stephen Bullen, John Green, Rob Bovey, Robert Rosenberg, Brian Patterson

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    2nd December 2004
    Posts
    44

    Re: vba functions list

    Quote Originally Posted by tinyjack
    Have you tried the Excel help files?

    TJ

    Yes, but very dry and difficult to maneuver through. also can't find a way to print just list of "functions".

    will use as needed, but will keep searching.

    thanks for assistance

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    2nd December 2004
    Posts
    44

    Re: vba functions list

    Quote Originally Posted by Bill Rockenbach
    For xl worksheet functions go to xl help and select keyword function

    For available xl functions in VBA go to VBA help and select keyword functions then select "list of worksheet functions available to Visual Basic"

    hope this helps

    i think i found where this is, but can't find function "dim". Just one of many "functions" i want to know about and lookup/query. Also cant get list to print without all the extra jargon.

    Greatly appreciate the response and it helped me get closer to goal.

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    10th August 2004
    Location
    Canada
    Posts
    6

    Re: vba functions list

    -= RWC_Zippy =-

  8. #8
    Join Date
    26th January 2003
    Location
    UK
    Posts
    4,683

    Re: vba functions list

    I have said this lots of times in the passed - trying to mass bag information is not a good way to go, i know and understand thats a good thought but trust me, i used to do that and ended up with 15 files full of printed stuff i could never use and ended up playing with codes i had, i learnt very very little.

    IMO what you need to stay in one place OzGrid is fine [could be anywhere] and read the post and try to understand them, forget the heavy stuff, read the ones you kind of know, say 'find' [could be sum or sum in VBA] has been posted today twice so you can then say OK and search for find and read all the posts, that was you see a lot and will pick up small bit.

    So if your working on something then search for it, and read all the posts some will not help others will, just move on from any that are to much for you and read what you can.

    Now you can say ah ha !! I need to know XYZ and if needs be post the question for help giving as much details as you can, theres always some one [most of the time] willing and able to help, might be a few hours sometimes but sure generally your get help and so you can do you work. Do this as much as you like and use OzGrid for help thats why we all help, we like to.

    Do not ever thing that a question is to easy or simple or anything like that, no one will be unhelpful, but please use the search before posting a question as your get so much more that way, not that i am saying dont post the question, just research a bit and you pick up so much more, i searh ozgrid every day for my work and edits codes all sort its a good way to work.

    Try search 'Variables' not dim see what comes up.. sites offer help but...
    Double 8 bytes # Double-precision floating-point number (which is more precise for very large or very small numbers) ranging from -1.79769313486232E308 to 1.79769313486232E308.
    The Variables Doble is explained fully here but hardly helps. what you need to know is

    VB:
    Dim Jacks_Number As Double 
    
    
    This will not be a whole number and is for LARGE numbers, where as Single is for small numbers... more complex that that is a bit silly really - does that moke sence?

    Jack

    BTW variables are veryhard work and i would be very surprised if they are often badly or incorrectley used,again post a question if you need to check something, postteh code as well so we can look it over.

    Might be worth searching under my name say passed month and see there are very structured VBA procedures there is thats what you are looking for

    Excel Video Tutorials / Excel Dashboards Reports


  9. #9
    Join Date
    28th January 2003
    Location
    Solihull - England
    Posts
    8,677

    Re: vba functions list

    You may also find the articles here of interest

    Reddick Coding Conventions

    It is certainly good practice, especially as you start coding & before bad habits creep in (which we all do from time to time )
    Kind Regards, Will Riley

    Web Presence:
    Personal: Datasapien
    LinkedIn: Will Riley

  10. #10
    Join Date
    2nd December 2004
    Posts
    44

    Re: vba functions list

    Just hoping to find a quick list of "expressions" and their meaning. As i browse the forum and read the code, it would be nice to understand a little of the coding such as "dim", or "mod", or any other. This would be the reason for the "quick list".

    Your right, I don't want too much info. some of this coding is confusing enough. I just want to understand it better than yesterday.

    Take care & thanks.


    Quote Originally Posted by Jack in the UK
    I have said this lots of times in the passed - trying to mass bag information is not a good way to go, i know and understand thats a good thought but trust me, i used to do that and ended up with 15 files full of printed stuff i could never use and ended up playing with codes i had, i learnt very very little.

    IMO what you need to stay in one place OzGrid is fine [could be anywhere] and read the post and try to understand them, forget the heavy stuff, read the ones you kind of know, say 'find' [could be sum or sum in VBA] has been posted today twice so you can then say OK and search for find and read all the posts, that was you see a lot and will pick up small bit.

    So if your working on something then search for it, and read all the posts some will not help others will, just move on from any that are to much for you and read what you can.

    Now you can say ah ha !! I need to know XYZ and if needs be post the question for help giving as much details as you can, theres always some one [most of the time] willing and able to help, might be a few hours sometimes but sure generally your get help and so you can do you work. Do this as much as you like and use OzGrid for help thats why we all help, we like to.

    Do not ever thing that a question is to easy or simple or anything like that, no one will be unhelpful, but please use the search before posting a question as your get so much more that way, not that i am saying dont post the question, just research a bit and you pick up so much more, i searh ozgrid every day for my work and edits codes all sort its a good way to work.

    Try search 'Variables' not dim see what comes up.. sites offer help but...


    The Variables Doble is explained fully here but hardly helps. what you need to know is

    VB:
    Dim Jacks_Number As Double 
    
    
    This will not be a whole number and is for LARGE numbers, where as Single is for small numbers... more complex that that is a bit silly really - does that moke sence?

    Jack

    BTW variables are veryhard work and i would be very surprised if they are often badly or incorrectley used,again post a question if you need to check something, postteh code as well so we can look it over.

    Might be worth searching under my name say passed month and see there are very structured VBA procedures there is thats what you are looking for

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. thecrumb.com » ColdFusion 8 - List of New Functions?
    By Dave Hawley in forum Excel Formulas (No Questions)
    Replies: 0
    Last Post: July 10th, 2008, 02:31
  2. List of Excel Functions
    By Belinda Li in forum EXCEL HELP
    Replies: 3
    Last Post: November 2nd, 2004, 23:41
  3. [Solved] Formulas : List of Built-in Functions
    By Brian Walters in forum EXCEL HELP
    Replies: 3
    Last Post: February 5th, 2004, 01:11
  4. List of Volatile functions?
    By FWind in forum EXCEL HELP
    Replies: 2
    Last Post: March 18th, 2003, 19:54

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
  •  
porno