Announcement

Collapse
No announcement yet.

vba functions list

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    Re: vba functions list

    Have you tried the Excel help files?

    TJ
    Oh dear I need a beer
    Online Motorsport Game

    Comment


    • #3
      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
      Bill
      Tip: To avoid chasing code always use Option Explicit.

      Comment


      • #4
        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
        Bill
        Tip: To avoid chasing code always use Option Explicit.

        Comment


        • #5
          Re: vba functions list

          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

          Comment


          • #6
            Re: vba functions list

            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.

            Comment


            • #7
              Re: vba functions list

              Try here:

              http://www.beyondtechnology.com/vba008.shtml
              -= RWC_Zippy =-

              Comment


              • #8
                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

                Code:
                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

                Comment


                • #9
                  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

                  LinkedIn: Will Riley

                  Comment


                  • #10
                    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.


                    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

                    Code:
                    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

                    Comment


                    • #11
                      Re: vba functions list

                      Excel 2003:

                      Try http://www.techonthenet.com/excel/fo.../index_vba.php or http://www.dummies.com/how-to/conten...ogramming.html

                      Microsoft has http://msdn.microsoft.com/en-us/libr...ice.11%29.aspx but it's just a list with no links or information.

                      Comment


                      • #12
                        Re: vba functions list

                        Is there really not a single source that explains what each code does? I don't get how the community can exist without a code dictionary. All those links you provided are not complete codes. They're all missing the simplest dim command, among many others. Is there a complete VBA code dictionary or not? And if not, is the most efficient way of learning this language is by searching every single code on google, reading 5 different threads, and maybe creating a thread just to understand how the language works? I'm just curious as to why such a list does not exist. I'm trying to learn VBA too, and I find all the google searches more time consuming than if I had a complete list of codes with explanation. An example for each would be even better.

                        Comment

                        Working...
                        X