Solved

Excel for Mac VBA

Posted on 2016-08-22
2
34 Views
Last Modified: 2016-09-12
I have an Excel file that allows for the right-click function for forms in Excel for Windows. When you open the form using Excel for Windows and place your cursor in the data field, you can right-click your mouse or trackpad and the copy/paste function/menu appears.

This happens because of the macro contained in the file. Otherwise the copy/paste function does not work on right-click.

The current macro is written for Windows and does not work in Excel for Mac.

Can someone help
Copy_of_rightclick.23105120.qylg4iuo.xls
0
Comment
Question by:Chet Powell
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 18

Accepted Solution

by:
xtermie earned 500 total points (awarded by participants)
ID: 41766754
Excel MVP Ron De Bruin is compiling a comprehensive page detailing differences between VBA on the PC and the Mac that can help you in finding the conversions that need to be made
http://www.rondebruin.nl/mac.htm

For the problem at hand please try the above guide as I don't have a Mac
I will try to rewrite it on the fly using Ron's guide but that will take a while
0
 
LVL 18

Expert Comment

by:xtermie
ID: 41793897
Good comment and suggestions provided but not feedback from the author
0

Featured Post

Scamming the Scammers!

Have you ever heard of Scam Baiting?
It's a highly entertaining sport that you can participate in.
Introduction to beating scammers at their own game and how you can help
Share your thoughts, ideas and experiences on the topic.
Links to top Anti-Scam resources provided.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question