Hi Everyone,
I have purchased the DVD "Excel VBA ad Macros with Mr Excel" to learn how to write my own Macro's and it's great, however, I would like to know if there is an exercise book availble anywhere to help with practical experience.
What I'm looking for is a book of exercises which start with simle macros and get progressivly harder as you move through the book.
So, for example, exercise one would be "Write a macro which colours a given cell blue and puts a border around it each time Ctrl K is pressed"
With solutions at the back of the book.
It's just for ideas on Practice Macros that I could write.
Does such a thing exist or is there a free resource on the internet somewhere?
Thanks,
Jay3
I have purchased the DVD "Excel VBA ad Macros with Mr Excel" to learn how to write my own Macro's and it's great, however, I would like to know if there is an exercise book availble anywhere to help with practical experience.
What I'm looking for is a book of exercises which start with simle macros and get progressivly harder as you move through the book.
So, for example, exercise one would be "Write a macro which colours a given cell blue and puts a border around it each time Ctrl K is pressed"
With solutions at the back of the book.
It's just for ideas on Practice Macros that I could write.
Does such a thing exist or is there a free resource on the internet somewhere?
Thanks,
Jay3