Hi All,
I would like to know where can I find a good resource to learn about VBA syntax. I have VBA books and there are some examples of code in there but when I'm trying to read someoneelse's code I just get into commands or syntax I don't understand. For example I would like to be able to go some site and decifer what this line (or it's parts) means:
If(cnt < MAXTEST, sDigSep & String(MAXTEST - cnt, "9"), "")
Where can I find such information?
Thanks.
Last edited by rinser; 04-11-2009 at 09:53 PM.
Well, I'm not too experienced but it looks to me like that isn't VBA. You don't use parantheses on IF statements in VBA.
Regardless, I've learned most of what I have on this site. Just look at people's questions and try to find the answer. When they do get answered, compare the answer to how you would have answered it.
The best way to learn is just to do it. Repition helps
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
Hi davegugg,
Thanks for advice, indeed following the posts and answers and trying to find solutions is I guess the best way to learn VBA. I am learning from a book and it helps to see real-world examples.
You guessed about the code: that's not VBA its VB and with some errors on top.
Hi rinser
Are you sure you're not forgetting one "i"?
IIf(cnt < MAXTEST, sDigSep & String(MAXTEST - cnt, "9"), "")
Last edited by lecxe; 03-25-2009 at 02:30 PM.
Hi ,
Indeed the formula was IIf
By the way if you need a challenge you could take a look at my other posts
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks