Have you tried the Excel help files?
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.
Have you tried the Excel help files?
Oh dear I need a beer
Online Motorsport Game
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
Originally Posted by Bill Rockenbach
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.
-= RWC_Zippy =-
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 isDouble 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.
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?VB:Dim Jacks_Number As Double
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
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 )
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
There are currently 1 users browsing this thread. (0 members and 1 guests)