I don't know if it's the Aha moment you are after. But in my programming 101 class the lecturer outlined the maximum-contiguous subsequence problem (which sounds very boring). Solved it once and then solved it two more times each time making it more efficient. That was my 'aha' moment that I decided I wanted to be a programmer. I suspect that this is the most important learning moment - what is it in programming that…
Not quite sure actually. I've always been fascinated with computers and the web from a young age. And I've gotten to a point where I have (at least what I'd like to think of as) great ideas and not being able to program is what's been "holding me back" from executing them. So, I bit the bullet and decided to start learning how to program.