PDA

View Full Version : VBA test



Andrew01
04-11-2012, 05:34 PM
Hi,
I have no prior experience with VBA and I have a VBA test for a trading role coming up soon. I have studied and understand most of functionx's tutorials for VBA for excel. I am assuming that the emphasis of the test will be on VBA for excel, however they are not providing further information. I was wondering if there was anything that you might suggest I should focus on? Thank you very much for your help.

Andrew.

Bob Phillips
04-12-2012, 12:28 AM
To be perfectly honest, if VBA is an important part of the job, I would forget it. To be taking a VBA test when you have no experience is asking to for an uncomfortable experience at best, possible ridicule.

VBA like other development tools is only really understood by use and practice. The test could throw up anything at you. It is unlikely that you will get a question such as what does the Delete method do, but more likely you would be asked to describe two methods for deleting rows based upon a condition, describe the pro and cons of each approach.

I know this is not what you want to hear, but I fear you are exposing yourself.