Solved

Excel for Mac VBA

Posted on 2016-08-22
2
23 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
  • 2
2 Comments
 
LVL 17

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 17

Expert Comment

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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
We could spend the next millennium discussing the differences of the Mac and Windows platforms. The next century will continue to have fanatics on both side of the equation and neither side will win the war. However, that’s not why we are here. W…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

911 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now