Help needed for learning excel vba

[chikita]

Hi everybody, i m a newbie for Excel Vba.I want the help file or any other resources for learning the basics of excel programming.Please anybody provide me the details if they know for learning and starting to write programs in excel.I dont know programming.i had never learnt progrmming in my life till date.so anybody please provide the way or resources for learning the VBA .
thanks and bye
chikita

 

[clut]

One of the best ways to learn is to open Excel, click on the 'Tools' menu, then 'Macro' then 'Record New Macro'. Click ok to accept all the defaults.

Do a few things in Excel, like type some text in a few cells, then click the 'Tools' menu, 'Macro', then 'Stop Recording'.

Whilst you were typing into cells Excel was writing the code for how to do this. click the 'Tools' menu, 'Macro' then 'Visual Basic Editor'. On the left click the little + next to 'Modules' and then double click on 'Module1'. You should now see the VBA code that Excel wrote to do the things that you did earlier.

You can then modify this code to try and make it do other things. If you're really stuck with how to get code to do a certain task. record yourself doing it in Excel, and then look at the code that Excel generated for you.

 

[DougStroud]

That is a really good question. I asked it when I was starting, and I am still asking questions....
What is your level of Excel and what is your level of programming?

What I have found to be helpful is the book by Walkenbach, VBA for Dummies. Everything else was too much info in the beginning. I have no programming experience, so I really had no idea of what I was doing or what I was getting into when I started.

Yes the macro recorder is a really good thing, but I did not begin to appreciate it until I really began to understand the idea of VBA was a Object oriented language and what that really meant.

Understanding the VBA help module, not just using it, but how to use it, what all the different things are....

I also joined VBAExpress.com. It does not have the same amount of people contributing or helping as MrExcel.com has, so the response time with answers or amount of answers is not as quick or robust, we are downright spoiled here with all the great people, but the board members there are just as nice and willing to help and it is dedicated to VBA. There you can get a lot of great examples to study, which is where I am now, studying other people's work which really helps.
They also offer a class which I am enrolled in and find it very helpful.

Other than that, post a lot and good luck,

TA,

Doug