Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-19-2022, 06:15 AM
TangoAlphaZulu TangoAlphaZulu is offline Just starting to learn VBA.  A few questions on getting started. Mac OS X Just starting to learn VBA.  A few questions on getting started. Office 2016 for Mac
Novice
Just starting to learn VBA.  A few questions on getting started.
 
Join Date: Jul 2022
Posts: 3
TangoAlphaZulu is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 07-20-2022, 06:36 AM
BobBridges's Avatar
BobBridges BobBridges is offline Just starting to learn VBA.  A few questions on getting started. Windows 7 64bit Just starting to learn VBA.  A few questions on getting started. Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

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.
Reply With Quote
  #3  
Old 07-21-2022, 02:53 AM
Debaser's Avatar
Debaser Debaser is offline Just starting to learn VBA.  A few questions on getting started. Windows 7 64bit Just starting to learn VBA.  A few questions on getting started. Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

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.
Reply With Quote
  #4  
Old 07-22-2022, 05:50 AM
TangoAlphaZulu TangoAlphaZulu is offline Just starting to learn VBA.  A few questions on getting started. Mac OS X Just starting to learn VBA.  A few questions on getting started. Office 2016 for Mac
Novice
Just starting to learn VBA.  A few questions on getting started.
 
Join Date: Jul 2022
Posts: 3
TangoAlphaZulu is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


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
Just starting to learn VBA.  A few questions on getting started. FREE resources to learn M$ products... zyzzyva57 Office 4 05-16-2009 07:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:56 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft