I recently purchased and read MSO Exce 2003 Programming Inside Out to learn
how to write code in Visual Basic for Applications. It has a lot of useful
information; but I found it difficult to follow and at the end I still
couldn't execute even a simple task such as a dialog box. Could anyone
recommend other sources for learning VBA that are easier to read, have clear
examples, and easy to do practice exercises?
--
molinaram

I've tried books and tutorials but if your like me, you have to learn by
doing. I learned a LOT here by first looking through the list of functions
available to excel, and then trying to perform these functions through code,
and asking questions when I got stuck. I could read all day but still not
complete a simple task, do a search for what you want and I'm sure you will
find instructions on how to do it yourself.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"molinaram" wrote:

I recently purchased and read MSO Exce 2003 Programming Inside Out to learn
how to write code in Visual Basic for Applications. It has a lot of useful
information; but I found it difficult to follow and at the end I still
couldn't execute even a simple task such as a dialog box. Could anyone
recommend other sources for learning VBA that are easier to read, have clear
examples, and easy to do practice exercises?
--
molinaram

John, thank you for your advice. You are right. Practice makes perfect. I
use this site all the time for examples of code that I can use in my own work
and have found it to be invaluable; however, I feel like I'm cheating.
--
molinaram


"John Bundy" wrote:

I've tried books and tutorials but if your like me, you have to learn by
doing. I learned a LOT here by first looking through the list of functions
available to excel, and then trying to perform these functions through code,
and asking questions when I got stuck. I could read all day but still not
complete a simple task, do a search for what you want and I'm sure you will
find instructions on how to do it yourself.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"molinaram" wrote:

I recently purchased and read MSO Exce 2003 Programming Inside Out to learn
how to write code in Visual Basic for Applications. It has a lot of useful
information; but I found it difficult to follow and at the end I still
couldn't execute even a simple task such as a dialog box. Could anyone
recommend other sources for learning VBA that are easier to read, have clear
examples, and easy to do practice exercises?
--
molinaram

No one person will ever know everything about Excel, but all of us together
have it pretty well covered :) Most of it isn't knowing everything, its how
to find the answer, this place gets you that, or close enough that you can
adapt it yourself. Do that enough and you will be surprised. I come here and
help where I can, when I see something that looks interesting to me but don't
know the answer, I hit the notify me of replies button and wait for the
answer, its an awesome learning tool! Keep at it and don't feel guilty!
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"molinaram" wrote:

John, thank you for your advice. You are right. Practice makes perfect. I
use this site all the time for examples of code that I can use in my own work
and have found it to be invaluable; however, I feel like I'm cheating.
--
molinaram


"John Bundy" wrote:

I've tried books and tutorials but if your like me, you have to learn by
doing. I learned a LOT here by first looking through the list of functions
available to excel, and then trying to perform these functions through code,
and asking questions when I got stuck. I could read all day but still not
complete a simple task, do a search for what you want and I'm sure you will
find instructions on how to do it yourself.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"molinaram" wrote:

I recently purchased and read MSO Exce 2003 Programming Inside Out to learn
how to write code in Visual Basic for Applications. It has a lot of useful
information; but I found it difficult to follow and at the end I still
couldn't execute even a simple task such as a dialog box. Could anyone
recommend other sources for learning VBA that are easier to read, have clear
examples, and easy to do practice exercises?
--
molinaram