2 Answers

• Reputation: 2398 Q&A: 49 0 8 1422 164 0 Classifieds: 0 0 what's this? Follow Following 1

  0 0 One way to get started with VBA and macros is to just use the Record Macro feature in Excel. Start recording and then copy/paste a range of cells, add some formulas, etc. Then, see what the self-generated code looks like. That will give you an idea of the structure and syntax of VBA. It didn't take me long before my code was much better than the self-generated code, but this will point you in the right direction. Once you have an idea of what you want to do, the various Help tools that come with Excel are indeed helpful. One caveat: I did all of this in Excel 2003. I was a bit lost when 2007 came out. Mahtli69 answered in Science & Technology about 1 year ago | Report 1 comment by internet_jen… 0 0 Awesome, I didn't realize you could look at the code of the recorded macros. That's how I leaned a lot of what I know about html, looking at the code in Dreamweaver as I was changing things around. internet_jen commented about 1 year ago | Report Enter your comment or ask a new question preview THIS IS A PREVIEW: Click "Post" to submit it or "Edit" to make changes. edit Please wait… This could take a minute if the tubes are clogged.

  Share this answer with a friend:

• Reputation: 1610 Q&A: 27 0 12 879 49 0 Classifieds: 0 0 what's this? Follow Following 0

  0 0 Not exactly, but I taught myself both PowerShell and VBScript from books and supplemented with some websites. Offhand, I remember two. I spent a lot of time on 4guysfromrolla.com when learning VBScript, and I think they also cover VBA. The Microsoft Script Center website (I liked the "Hey, Scripting Guy!" column) is also good and has VBA content. I would start with Script Center and go onto 4guys when you're a little more experienced. If you haven't taught yourself a programming language before, the best advice I can give is to give yourself specific things you want to do--start simple--and study the code samples until you really understand what you're doing. CleverScreenName answered in Science & Technology about 1 year ago | Report Comment on this answer Enter your comment or ask a new question preview THIS IS A PREVIEW: Click "Post" to submit it or "Edit" to make changes. edit Please wait… This could take a minute if the tubes are clogged.

  Share this answer with a friend: