VBA: Copy and Paste with a TextBox do not work on Mac

Eugene Z 20 Reputation points
2025-06-17T13:28:21.35+00:00

VBA for Word; but there is no coding involved.

Create a UserForm. Add a TextBox. Run it.

On Windows - you can Copy and Paste to/from the TextBox - vs the Clipboard.

On MacOS - you cannot.

(at least, it never worked for me - please post if it works for you! On Mac.)

Developer technologies | VB
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Omkara Varshitha Kunapalli (INFOSYS LIMITED) 1,985 Reputation points Microsoft External Staff
    2025-11-14T04:35:12.19+00:00

    Hello thanks for reaching out!

    Open Microsoft Word.

    • Start a blank document.
    • Open the VBA Editor.
      • Windows: Press Alt + F11.
        • Mac: Press Fn + Option + F11 or go to Tools > Macro > Visual Basic Editor.
        • Insert a UserForm.
          • In the Project Explorer, select your document/template.
            • Go to Insert > UserForm Add a TextBox control.
            • Open the Toolbox (View > Toolbox if hidden).
            • Drag a TextBox onto the UserForm.
            • (Optional) In the Properties window, set MultiLine = True and EnterKeyBehavior = True if you want multi‑line input. Create a procedure to show the form.
            • Insert a new Module (Insert > Module).
            • Add this code: Sub ShowForm()     UserForm1.Show End Sub Run the UserForm.
              • Press F5 or run ShowForm from the Macros list.
              • Test copy/paste behavior.
                • Try copying text from another app and pasting into the TextBox.
                  • Try copying text from the TextBox and pasting elsewhere Results
                  • On Windows: Copy/paste works normally in the TextBox.
                  • On Mac: Copy/paste does not work in the TextBox. Explanation
                  • This is a known limitation of VBA UserForms on Mac.
                  • Clipboard integration is incomplete — it’s not a coding error.
    • Microsoft has not provided a fix; it’s a platform restriction.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.