In the 22nd session of Chandoo.org podcast, lets do some macros.
VBA (or macros, automation) is a mystery for many of us. So in this podcast, lets unravel the mystery behind it and get you started with the awesome world of automation.
How to get started with VBA Macros?
More tips, information, tutorials & resources on VBA.
Learn from basics to advanced VBA in a self-paced, on-demand online training from me. With more than 24 hrs of video training material, 50 lessons, 50 example macro workbooks, home work exercises, 2 class projects and an online community, you can quickly learn ways to automate your work & save time.
Please click here to know more about this program.
Are you new to VBA? What is stopping you from learning it?
When I first heard about VBA, I was not very interested (as explained in the podcast). But later when I got a job, I realized the potential of VBA and quickly embraced it.
What about you? Are you a VBA newbie? What is stopping you from learning it? Please share your fears and difficulties in the comments so that I can help you.
My reason for not learning VBA is the fear of Microsoft changing things around. I've seen several cool spreadsheets go completely useless, because of VBA that stopped working. As it was explained to me, this usually happened when Office was upgraded in such companies.
I must admit sometimes it's a problem to avoid VBA. Less interactive elements are available, charts can't always do exactly what I would like best, I have no idea how to force a spreadsheet to open full screen otherwise and stuff like that. But I do create awesome, dynamic tools this way and they work fine in all 2007+ versions of Excel. I found creative answers to pretty much all problems I came along.
One problem that really bothers me though is the use of the camera tool. I tried INDEX, OFFSET and INDIRECT, but I always get the same problem. It works fine, untill I restart my computer. When I open such a spreadsheet, the camera won't update untill I go to the source sheet and move my cursor over the source cell. After that the camera will keep working perfectly, even when I restart Excel. Do you happen to have any idea what's causing this problem?
For the record: I use named formulas in the camera link and calculation is set to automatic. Since there's always an interactive element like a radio button (or whatever) involved, a value is changed on the spreadsheet. So I really don't understand why it doesn't update right away. This frustrates me, because the camera has so much potential with layered, transparant images and combining multiple charts. But I don't want to force my customers to use a work-around (moving mouse over camera source) to get it started.
Sorry for the long off-topic camera text, but I really hope you can help me out. It would mean the world to me.
Anyway, keep up the good work and best of luck to you!
actually I tried sometime to work with VBA but sometime I succeeded and sometimes i couldn't give the right coding. I the fear to learn it is the time that I will need to spend on it. And another fear is that I will have to learn a lot in VB. Actually I have all my studies in computers and I know that Its time taking to learn a computer language. That's what makes me not to get involved in VBA's. And one more thing that I am sure about is If I start learning one interesting thing about VBA's through your mails, I will learn it one day :-). Thanks for this awesome platform to learn about excel.
i want to join your face to face class for excellency in excel & BI Analysis programme.
Can you please share me the next Classes in Delhi NCR.