The best way to learn is to do. Identify a need and set off to fill it.
IRStuff
Try tackling some problems: first small, then bigger.
Great advice guys and great help for my problems when I post.
The only fly in the ointment is a tendency to stick with what you know.
I started out a long while back using IF statements to do what I needed.
But now I am the IF king.
No matter what the problem, I break my calculations down into blocks and then whatever I need to do, I write it using IF statements where possible.
I can nest them the legal 7 deep and I have routines to extend that to any reasonable number of IF statements.
But I suspect that some problems are better solved using a different approach.
I found the proof of this just today.
A couple of months back I needed one of my old spreadsheets, written a couple of years back, but now lost in the hard drive of a dead computer.
I decided to rewrite it and so I did, mainly using IF statements.
Though it worked I nearly went mad writing it; not just because it was nightmare to write, but because as I was writing it I couldn't help remembering it went much quicker, simpler and better the first time. But how?
Today I found a copy buried in this laptop.
I opened it up and discovered alien code, all neatly organised and written as if it had all gone in one flowing sequence.
So evidently, the IF statement isn't the only way to do things.
Now I must devote some time to figuring out what the heck I did(Probably with help from here).
So I guess I now have to move on to the next good advice here:
Pick up the basics of how to get data from the spreadsheet into VBA and back again.
Learn the basics of Basic; data types, control statements, and arrays etc.
Start experimenting with some UDFs and recorded macros.
(Doug and echoed by Electric Pete).
JMW