jueves, 21 de noviembre de 2013

More excercises.

Here i have more practises with macros and visual basic programming:

Macros and programming with visual basic.Alphabet program.

We've made some exercises about programming on excel.First you will have to go to : herramientas>macros>grabar macro then stop the recording and go herramientas>macros>ver macros>modificar (vista>macros in excel 2007)
Now you have your visual basic window ready to start programming.
An exercise we made was transforming caps into minus letters in the following column.For this we have to write the letters on the first column , and ther corresponding ASCII code on the next.
Now we go for macros and we do the following:

We press play and go back to the columns and we have aour alphabet converted.