Thursday, October 27, 2005

Weekly VBA warmup!

OK... ready for this weeks VBA warmup?? Try creating subs for these two problems below (using the InputBox and MsgBox functions, together with a mystery function that you'll have to find!
  1. After Mark Latham's recent outbursts, the Labor party has decided to remove the letter 'l' from the alphabet and by replacing it with a 't'. Create a new Sub called LathamsLegacy that will prompt the user to enter text, and will return a MsgBox displaying the same text, but with every 'l' replaced with a 't'.
  2. Before the sale of Telstra, Sol is keen to rename the company back to it's previous name of Telecom. Create a new Sub called Telecom that will modify any text entered by the user by replacing the word "telstra" with "telecom".

0 Comments:

Post a Comment

<< Home