Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 76
  • Last Modified:

Excel for Mac VBA

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
Chet Powell
Asked:
Chet Powell
  • 2
1 Solution
 
xtermieCommented:
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
 
xtermieCommented:
Good comment and suggestions provided but not feedback from the author
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now