• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Advanced VBA macro courses

J

joharmenezes

Member
Where can I get advanced VBA & macro courses? In an interview I was made to take an excel test where they asked me to create a button which when clicked imports data from another excel and sorts it. I was not able to complete this test and hence was not selected. I did not know that companies used such advanced form of excel. But now that I know I would like to learn VBA and macros in detail.
 
Hello T100,


There are many such courses available online. But you can think of joining Chandoo's online VBA classes.It is, indeed, very helpful, will teach you from the basic, and covers lot of real world examples. Please visit the below link for further details:


http://chandoo.org/wp/vba-classes/


Kaushik
 
Hi, T100!

Parallel with any course you surely will find useful the self-taught method of trial an error. You may profit from the embedded macro recorder and just take a task to accomplish (e.g., the exercise you were asked at the test), press the macro recording button (icon worksheet icon at left bottom of the screen, just aside the Ready message), perform the manual operations that you need to do the job, and then press again the recording button to end macro recording. Then goto to VBA editor with Alt-F11 and check in the modules section for the new code: you'll find a lot of information there, you might want to optimize the generated code, and hence learn a lot from this process.

Regards!
 
SirJB7, I think you got the solution to the problem. The interviewer had given me a clue before the test and talked on the same lines as per what you have said. I could solve the sorting problem just like you have advised but I don't know how an embedded macro in vba can help import data from another excel?
 
Hi T100,


Another good place to learn VBA is this forum itself.


I would like to advise you the following:


1)Visit the forum everyday (if possible)


2)Analyze the solution given by other members on many VBA topics (you can search the topics by google custom search), understand them and try to apply them in your daily work. And yes, recording the macro for any action you perform manually in excel, would always help to learn better.


2)Gradually, try to take initiative to solve the problems posted by other in this forum.


Trust me, you will fill difference w.r.t. learning in a very short period of time.


Kaushik
 
Hi ,


I suggest you read at least one good book on macros ; choose any of John Walkenbach's books from the following list :


http://www.amazon.com/Best-Excel-VBA-Books/lm/3P9T4WT9MA29P


Narayan
 
Hi, T100!

Almost everything you do manually in Excel could be automatized into a macro, and surely it can be recorded using the built-in macro recorder feature. A way to import data from another Excel could be achieved in two ways, depending on if the source workbook is open.

Give a look at this samples files (code in target):

https://dl.dropbox.com/u/60558749/Advanced%20VBA%20%26%20macro%20courses%20-%20Source%20%28for%20T100%20at%20chandoo.org%29.xlsm

https://dl.dropbox.com/u/60558749/Advanced%20VBA%20%26%20macro%20courses%20-%20Target%20%28for%20T100%20at%20chandoo.org%29.xlsm

Regards!
 
Hi T100,


Even I am new to VBA and I would like to share few things which i follow.


* Maximum usage of help window - The reference library in help function has all the major topics in it.


* Use youtube videos - there are lot of videos which has very neat explanation of concepts and codes.


* As Kaushik says try learing with the VBA posts in this forum.
 
You must log in or register to reply here.
Back
Top