Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

2017 ACTUARIAL SALARY SURVEYS
Contact DW Simpson for a Personalized Salary Survey

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 04-25-2018, 12:55 PM
Steve White Steve White is offline
Site Supporter
Site Supporter
 
Join Date: Sep 2001
Posts: 2,983
Default Opening the Immediate window for Excel VBA macros (on a mac, preferably)

Anyone know how? It's not just "preferably" for a Mac. It's got to work on a Mac, and most on-line suggestions are not Mac-specific and don't seem to work.

My particular situation: using Microsoft 365 personal, on an IMAC. Using Excel. Using a macro. I want to open the immediate window to view results, and can't figure out how.

I'm pretty sure that I have had an immediate window open before, but don't remember how, and it could have been before my most recent operating system change (now on High Sierra).

If you want to make suggestions for a Windows-based environment, I'll be glad to try them.
Reply With Quote
  #2  
Old 04-25-2018, 01:01 PM
SlowMotionWalter's Avatar
SlowMotionWalter SlowMotionWalter is offline
Member
CAS
 
Join Date: Jun 2013
Posts: 12,588
Default

Is it not an option in the menu bar under view?
__________________
Quote:
Originally Posted by bigb View Post
You should learn to communicate in a serious manner before you expect a serious answer.
Spoiler:
Quote:
Originally Posted by Kangaz wit Attitude View Post
Force of habit, 2pac's been typing "88" a LOT since Trump got elected.
Quote:
Originally Posted by JMO View Post
You ought to see the bush. It's impressive.
Quote:
Originally Posted by Pikachu
10:53 pm: some ppl dont take advices well
Quote:
Originally Posted by mayo fan
9:45 pm: ao fan would be hot covered in mayo!
Quote:
Originally Posted by Snikelfritz
if you'd like I can come visit and dress up like a girl and get in some fights
Quote:
Originally Posted by Kaner3339 View Post
i think everyone needs to do this type of thing to get a dose of reality and straighten people up. it's kinda like going to the mountains and becoming a monk except it's with hundreds of potatoes and a lot of stoners with tattoos in a kitchen
Reply With Quote
  #3  
Old 04-25-2018, 02:11 PM
campbell's Avatar
campbell campbell is offline
Mary Pat Campbell
SOA AAA
 
Join Date: Nov 2003
Location: NY
Studying for duolingo and coursera
Favorite beer: Murphy's Irish Stout
Posts: 84,136
Blog Entries: 6
Default

Quote:
Originally Posted by SlowMotionWalter View Post
Is it not an option in the menu bar under view?
I don't have Microsoft 365 on my Mac, but in older versions of Excel for Mac, when you're in the VBA editor, you pull down the View menu, and there should be something saying Immediate Window:



Looks like there's a keystroke combo, too.
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #4  
Old 04-25-2018, 02:35 PM
Steve White Steve White is offline
Site Supporter
Site Supporter
 
Join Date: Sep 2001
Posts: 2,983
Default

Quote:
Originally Posted by SlowMotionWalter View Post
Is it not an option in the menu bar under view?
Thanks. That is one of the online suggestions I found, that don't seem immediately applicable to my Mac situation.

The attachment is what the View menu looks like. Perhaps there is an option to customize what shows up, but if so I'm forgotten how to do that.
Attached Images
 
Reply With Quote
  #5  
Old 04-25-2018, 02:37 PM
campbell's Avatar
campbell campbell is offline
Mary Pat Campbell
SOA AAA
 
Join Date: Nov 2003
Location: NY
Studying for duolingo and coursera
Favorite beer: Murphy's Irish Stout
Posts: 84,136
Blog Entries: 6
Default

That's the view menu for Excel, not the VBA Editor.

You need to open up the VBA editor from the Developer tab first.
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #6  
Old 04-25-2018, 02:51 PM
Steve White Steve White is offline
Site Supporter
Site Supporter
 
Join Date: Sep 2001
Posts: 2,983
Default

Quote:
Originally Posted by campbell View Post
I don't have Microsoft 365 on my Mac, but in older versions of Excel for Mac, when you're in the VBA editor, you pull down the View menu, and there should be something saying Immediate Window:



Looks like there's a keystroke combo, too.
Thanks. Slightly weird, in that when I first posted I didn't even have that View menu on the same available. There is one set of menus for Excel, and a separate set of menus available for each specific spreadsheet. I thought I remembered that their should be a View menu on the Excel bar, but I wasn't seeing it. Now I am, but it still doesn't have an Immediate Menu choice. Here's what I see. (I also see you made a subsequent post. That doesn't seem to do it either, but I'll post a screen shot of that effort, too.)
Attached Images
 
Reply With Quote
  #7  
Old 04-25-2018, 02:56 PM
Steve White Steve White is offline
Site Supporter
Site Supporter
 
Join Date: Sep 2001
Posts: 2,983
Default

I had Excel open, VBA editor closed. I chose the Developer tab. I chose the Visual Basic icon on the far left (you can see that icon here). It did open the Visual Basic editor. At that point the only "View" menu I see is the one on the Excel menu bar, and it's ghosted with no available options (and "Immediate window" is not even shown ghosted).
Attached Images
 
Reply With Quote
  #8  
Old 04-25-2018, 03:51 PM
SlowMotionWalter's Avatar
SlowMotionWalter SlowMotionWalter is offline
Member
CAS
 
Join Date: Jun 2013
Posts: 12,588
Default

What version of Office are you running? It should be under Excel | About Excel. Maybe 15.XX or something like that.
__________________
Quote:
Originally Posted by bigb View Post
You should learn to communicate in a serious manner before you expect a serious answer.
Spoiler:
Quote:
Originally Posted by Kangaz wit Attitude View Post
Force of habit, 2pac's been typing "88" a LOT since Trump got elected.
Quote:
Originally Posted by JMO View Post
You ought to see the bush. It's impressive.
Quote:
Originally Posted by Pikachu
10:53 pm: some ppl dont take advices well
Quote:
Originally Posted by mayo fan
9:45 pm: ao fan would be hot covered in mayo!
Quote:
Originally Posted by Snikelfritz
if you'd like I can come visit and dress up like a girl and get in some fights
Quote:
Originally Posted by Kaner3339 View Post
i think everyone needs to do this type of thing to get a dose of reality and straighten people up. it's kinda like going to the mountains and becoming a monk except it's with hundreds of potatoes and a lot of stoners with tattoos in a kitchen
Reply With Quote
  #9  
Old 04-25-2018, 03:57 PM
SlowMotionWalter's Avatar
SlowMotionWalter SlowMotionWalter is offline
Member
CAS
 
Join Date: Jun 2013
Posts: 12,588
Default

If it's less than 15.39.0 you need to update Office. This is the first update where Office 16 for Mac has a real VBA editor. Older versions of Office for Mac had a real VBA editor, but there apparently was a delay in porting it over for 16.
__________________
Quote:
Originally Posted by bigb View Post
You should learn to communicate in a serious manner before you expect a serious answer.
Spoiler:
Quote:
Originally Posted by Kangaz wit Attitude View Post
Force of habit, 2pac's been typing "88" a LOT since Trump got elected.
Quote:
Originally Posted by JMO View Post
You ought to see the bush. It's impressive.
Quote:
Originally Posted by Pikachu
10:53 pm: some ppl dont take advices well
Quote:
Originally Posted by mayo fan
9:45 pm: ao fan would be hot covered in mayo!
Quote:
Originally Posted by Snikelfritz
if you'd like I can come visit and dress up like a girl and get in some fights
Quote:
Originally Posted by Kaner3339 View Post
i think everyone needs to do this type of thing to get a dose of reality and straighten people up. it's kinda like going to the mountains and becoming a monk except it's with hundreds of potatoes and a lot of stoners with tattoos in a kitchen
Reply With Quote
  #10  
Old 04-25-2018, 04:15 PM
Steve White Steve White is offline
Site Supporter
Site Supporter
 
Join Date: Sep 2001
Posts: 2,983
Default

Quote:
Originally Posted by SlowMotionWalter View Post
If it's less than 15.39.0 you need to update Office. This is the first update where Office 16 for Mac has a real VBA editor. Older versions of Office for Mac had a real VBA editor, but there apparently was a delay in porting it over for 16.
Thanks. I'll have to investigate that but don't know what my options are. I have an Office 365 subscription and use Excel and Word through that. They said with Office 365 I would automatically have the latest versions. Checking via "About Excel", it says it is Microsoft Excel for Mac version 15.27, licensed via an Office 365 subscription.

When I first got the Mac, I had bought Excel for the Mac as purchased software, not subscription. For at least 2 years now I have used Office 365 because it lets me use Excel on a tablet as well.

I do feel I had the immediate window at some point after being on Office 365, but maybe I lost it during some release.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 06:22 PM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.39578 seconds with 10 queries