I'm sorry, but in my opinion you should find it out yourself. VB Script is supported at all MS Office products, so do the code there. At testing the problem solving is one of the most important skills. And asking help from forum at very simple question is not correct problem solving. It's rather cheating.
I don't mean to be nasty for you. I hope this is rather helping and encouraging you to find out things yourself. And also I hope this encourages you to try things you've never tried before.