At my new workplace, I've been learning and making a few scripts/macros in VBA to help out with work processes and so forth. Nothing major, but I've taken an interest in it and really want to take it a step further. A lot of this might be amateur-ish to many of you.
I guess I have two questions:
1) My programming is currently in VBA. I know things are different depending on the language used, but are there any general tips and DO's and DO NOT's that would help someone somewhat new at this? Example: I do comment often, but am not sure of certain conventions, like what makes a useful comment, or how to name functions/methods, etc. Things like that.
Are there language-independant guides to help me develop the right habits from the start?
2) Where do I go from here? I know VBA is like, novice-territory (at least where I'm dabbling in). My boss has mentioned to the extent that we use VBA, we would benefit from moving to something like C# (with Visual Studio as the IDE there), as compiling code+program execution time would decrease significantly.
We do a lot of things in Excel, and I've heard you can use datasheets or something like that to emulate that sort of UI in C#/Visual Studio.
Do I start looking at Visual Studio? I mean, who hasn't dabbled in the idea of making a quick RAD app for a smartphone these days? That would also be neat to look into. Maybe I'm 5 steps ahead of where I should be, but any insight would be helpful at this point.
I did take some programming courses a fair time ago, covering C++ and Java. I know some basic concepts, but it has been some time.
I love design work and have put what little I know into websites in the past. A lot of it these days is customizing existing CMS templates with some code and Photostop (for aesthetics).