Once upon a time I was trying to teach myself VBA, because I was responsible for some Word templates that relied heavily on it. I had a reference book and muddled through to the point that while I could look at code and get an idea of what it was going to do (and could thus cut and paste things to reuse them) I couldn’t write scripts from scratch.
Now I’m using Excel today and I *know* I should be able to write a macro that checks all the values in column B, and depending on what it finds there, puts in a date in column C (right next to the value.) So if b17 = 12345, c17 should be 10/10/04. Or something like that. Because I have a 900 line spreadsheet and I need to populate the c column based on what’s in B, and there are only 15 options for what’s in B. So I know WHAT I want the macro to do, I just don’t know how to get it to do it.
I’m going to go look for my VBA book at home tonight, but I don’t know if it was Word-specific or not. It probably doesn’t matter.
So enough about my day, how is yours?
