#1
|
|||
|
|||
Just starting to learn VBA. A few questions on getting started.
I am just starting to learn VBA (literally started last night). I downloaded the preview version of a tutorial from one of the many websites that pop up when searching for VBA tutorials. Link here
The story so far: The tutorial is written with Windows users in mind, and I am a Mac guy. I was trying to follow the instructions on page 11, and my screen does not match what the tutorial shows. I can't find any screen that looks like the properties screen they show. I woke up this morning with a few questions. Excel is the subscription version of Office for Mac. Version is 16.63.1 1. How do I get the properties window to show up on my Mac version of Excel? 2. Do I even need to start with buttons and the dialog windows? Again, I am totally new here. Not sure I even know the right questions. 3. Is there a better place to find learning materials than the one I linked to above? One that has Mac specific material would be great. Any pointers in the right direction will be greatly appreciated. Jeff |
#2
|
||||
|
||||
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. |
#3
|
||||
|
||||
You can't use ActiveX controls on a Mac, so that is not going to be particularly helpful to you. There is also still no userform designer so you won't be able to do any of that.
Developing on a Mac is frankly painful in current versions, and I don't see any prospect of that changing any time soon (it's been 6 years since they said they were working on a userform designer) given that Microsoft has no interest in VBA. |
#4
|
|||
|
|||
Bob,
You are right about not needing buttons. I've been playing with recording macros and I have been pleasantly surprised how much I can accomplish this way. Getting to look at the code once the macros are recorded is a big help. I may need buttons someday, but right now I think I will get along without them. Debaser, To illustrate hw much of a nOOb I am at VBA, I have no idea what ActiveX or user form designer is. Can I assume the buttons and such mentioned above require ActiveX? Can you explain further? Thanks, Jeff Last edited by TangoAlphaZulu; 07-22-2022 at 11:37 AM. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Why and how are spreadsheets useful for a programmer, and should I learn to use Excel? | zaerth | Excel Programming | 1 | 05-06-2022 01:41 PM |
How to learn VBA? | fransbosch | Word VBA | 8 | 12-17-2019 08:28 AM |
Resources for beginners trying to learn VBA!! | Charlesmartin | Excel Programming | 1 | 12-03-2019 08:04 AM |
Need to learn how to change Degre decimals into DMS | ferfer25 | Excel | 12 | 11-23-2013 11:11 PM |
FREE resources to learn M$ products... | zyzzyva57 | Office | 4 | 05-16-2009 07:31 AM |