Or do I need to learn something like C#, and how daunting would that be?
This depends on your current level with other languages. Within this community it seems reasonable to assume that many people have dabbled with VBA at some point. Personally, I have experimented with only a handful of languages and here is how I rate their difficulty on an overall scale of Learning / Implementing
Easiest
AutoLisp / HTML / CSS
VBA / VisualLisp / Javascript
C#
Hardest
If you have used VBA or would consider yourself proficient and it is the most "advanced" language you have used then you should be able to understand the same object-oriented concepts when stepping into C#. But there will definitely be a learning curve. I have invested a fair amount of time into taking on C# but I still feel as if I have BARELY scratched the surface. C# is a VERY capable language and thus has MANY methods of approach even for simple tasks. Kean's blog has provided me with many insights on how to accomplish tasks that I would not know how I could have accomplished them otherwise! If you're going to make the jump to C# I just recommend that you fully commit and invest time and effort because it will not be quick to adjust. Just work toward a goal and even when you mess up you'll still be learning, so don't quit.
Best,
~DD