Consulting

Results 1 to 2 of 2

Thread: copy / Paste and Textbox

  1. #1
    VBAX Regular
    Joined
    May 2005
    Posts
    6
    Location

    copy / Paste and Textbox

    I'd like to copy & paste data from textboxes to textboxes or sheet to textboxes.
    (Textboxes are placed on a userform)
    the command keys (Cde C and cde V) are not active.
    Copy and paste is available on Windows even the userform is modal, but not on Mac.

    is it a way to make it available on mac ?

  2. #2
    VBAX Tutor
    Joined
    Mar 2005
    Posts
    268
    Location
    Hi Jofx and welcome to VBAX!

    I wish I could give you some good news, but to my knowledge it's not available. Recent versions of Win Office allow you to choose modal or non-modal for userforms - Mac Office (based on an earlier version of VB) does not provide you this luxury. I don't believe any keyboard shortcuts for copy/paste are available in userforms.

    The RefEdit control works quite well. Perhaps you can use it to specify the location of data on your sheets, and theen include code in the userform to process the range and load the values into your form? If you need more flexibility, well, things are always possible but they get progressively more complicated and clunky.

    BTW, I use Office X, not 2004, so maybe something new is available, but I really wouldn't count on it - MS seem to be on a holding pattern as far as Mac VBA is concerned.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •