Two major things will help you. One is the help files which are invoked whenever you click on a word in a macro and then press F1. I am sure you have found that, but do you use it whenever you do not understand all about a keyword such as Dim?
The other thing is intellisense. When you are typing in a sub or function, the options for a command you are using will appear in a drop-down list. Try some of them and then press F1 to find out about it. For example, if you type Dim x as immediately you press the space after the as you will get a list of all the types you can define a variable as. This will be a lot of help to you. Also always click debug/compile on the menu before you run a procedure you have written. It checks that the syntax is correct, and shows you where they are wrong. In context of this, always have "Option Explicit" at the top of all modules. This forces you to Dim each variable before you use it, and it will show up any spelling mistakes in variable names. This list is best to help with specific queries rather than general requests for help. Always try to do as much as you can of a task before asking for help and then show us what you have done and what it is doing wrong. If there are any error messages write them down exactly and tell us, if it is possible to find out, what line the error occurred on. Above all, just keep writing and testing code and you will soon be one of the ones giving the answers on the list. Regards David Grugeon On 17 May 2013 20:00, Chaya <chayamon...@gmail.com> wrote: > Dear experts and all, > > I am trying to learn excel macros from initial steps. please provide > some advance tips to learn the source from initial. Actually, i am learning > by recording the macros and trying to get the logic, but it does not make > me fullfil to learn. even i reading ebooks and trying to practice in excel, > but no effective. > > After all, i use to get solution from google and from you all, even > after reading and practice i am not getting the logical and its scripts. > > Please advice me with your suitable suggestion and guidance. > > Say for small example : > > even today i don't know how to use "Dim" after reading books, i know > it is use for declaring values but i even don't know what and which value > are to be use and where. > > Please don't consider the above example, as it is just a small hint of > mine and provide me some tips or advice from where i can understand clearly > the logical coding and can write codes as per the necessity like you all. > > Thanks a millions to all. > > > Regards, > Chaya > > The excel learner :-) > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
