We help IT Professionals succeed at work.

Where's F1 for VBA help on a Mac ?

Where's F1 for VBA help on a Mac ?

Anthony
Comment
Watch Question

Anthony MellorChartered Accountant
CERTIFIED EXPERT

Author

Commented:
Points for speed!
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
Use fn + F1
Anthony MellorChartered Accountant
CERTIFIED EXPERT

Author

Commented:
nice try,  but

no fn key
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2011

Commented:
What kind of mac is it?
In the keyboard section in System Preferences you should be able to check the option to use function keys as normal function keys.
Anthony MellorChartered Accountant
CERTIFIED EXPERT

Author

Commented:
hang on ... there IS a  fn key!

well I never... testing...


edit: @rory yes done that
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2011
Commented:
f1 works for me in Excel 2011 if the keyboard is set up that way. Of course Mac VBA help is worthless, but that's a different story.
Anthony MellorChartered Accountant
CERTIFIED EXPERT

Author

Commented:
ok that helps ;-) (really i mean, to know it should/can work)


sigh, the joys of language, my tongue in cheek smiley is because of the pun on help.
Anthony MellorChartered Accountant
CERTIFIED EXPERT

Author

Commented:
oh, I see what you mean, first F1 deleted the word I had highlighted in a module and then after a delay loaded Help, which told me to go online for it and takes me here:

http://mac2.microsoft.com/vb/1033/default.aspx

which might be interesting as mac based I suppose.

Ok I'll play. At least I know what's supposed to work now.
Anthony MellorChartered Accountant
CERTIFIED EXPERT

Author

Commented:
answer seems to be a mix of both depending on keyboard settings, main point is that F1 is designed to work that way if we wish, which I wasn't sure about.
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Thanks for the points.

I'm not sure what your setup is, and you may be aware of this, but if you want to run XP or Vista or Win7 or any other version of Windows seamlessly side by side with OS X on your MAC you can by using Parallels software. I use it and except for having to use fn + F1 (and most of the other function keys) it's identical to being on a native PC. One caveat is that you'll need a non-OEM version of the Windows OS to install it on the MAC.
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2011

Commented:
Note: other options than Parallels exist, such as VMWare Fusion, or VirtualBox (which is free) or dual boot with Boot Camp. ;)