VBA (OCNW) Level 2

  Young Ranger 16:36 15 Aug 2003

My local college is offering this course and thought I might give it a go.

My knowledge of programmimg is zilch, so my first question is, is this suitable for a beginner ?

I use Excel in Office 2000 so what kind of prectical uses could I use VBA for ? For example, I have a spreadsheet containing in excess of 10,000 records. Would VBA enable me to extract data in a way that would be better than using the simple Data/sort tools ? (I don't have Access).

Without appearing to be unhelpful, the best solution is to ask your college whether the course is suitable for you.

The only specific advice that I could give you is that VoG must retire someday and somebody has got to take his place and that could be you if you get in to VBA now.

There are many things that you can do with VBA but to use your examnple above, the simple way IN THIS CASE is probably the best.


  Young Ranger 23:51 15 Aug 2003

I will of course speak to the college but I have always appreciated opinions from the users of this forum. I posed the question here as views expressed here often put a different shade on those expressed in the shop, or as in this case, college.

  Sir Radfordin 00:59 16 Aug 2003

If the course title has "Level 2" in it I'm guessing there is going to be a "Level 1" if so you may be wise to think about that first. It may be that the course has entry requirments anyway in which case you would have to meet those.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Honor 9 Lite review

18 Best Adult Colouring In Books 2018

HomePod review

Les meilleures séries Netflix (2018)