On the one hand, if I post even one reply here it'll discourage more knowledgeable folks from replying. On the other hand, I do know the answer to #2: No, you definitely don't need to start with buttons and dialogues. I write complicated programs in Excel and very seldom use forms, or even buttons; mostly when I want to control how a program works I have it look at certain "settings" that I put on a Settings worksheet.
Forms and buttons can be very useful and I wouldn't for the world discourage you from using them if you want to. I just think it's a complication you don't need when you're just setting out to learn.
I'm sorry I can't help you with the Mac version of Excel; I've been a Windows-only guy since the '80s. If it'll help make it up to you :-), I can coach you on programming in VBA. I'm assuming the language is the same in Mac and Win. Try emailing me at my Gmail account, robhbridges, and I can at least get you started on the plain programming stuff.
|