This is exactly why I started regularly frequenting the forum.
What I did was search the Excel Questions forum for threads that had already been solved by vba. I didn't look specifically at what the vba solution was but if I thought it was a problem I might be able to tackle then I went away and tried, eventually comparing my solution to the solution in the thread.
In most cases the solution thread was better than mine and I tried to learn from that. As my skills slowly developed I occasionally thought that my solution was as good or better that the posted solution so I would post mine too. Quite often the vba gurus would provide constructive criticism about my code and again that was a learning experience.
There is such a wide variety of vba questions in the forum it is a great source of 'practice problems' for all levels of ability.