Solved

Excel for Mac VBA

Posted on 2016-08-22
2
26 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 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

820 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