+ Reply to Thread
Results 1 to 4 of 4

Excel 2010 Cannot paste into a form textbox

  1. #1
    Registered User
    Join Date
    07-26-2017
    Location
    St. Louis, MO
    MS-Off Ver
    2010
    Posts
    8

    Excel 2010 Cannot paste into a form textbox

    I have a textbox within a frame on my form. A user wants to copy and paste data into this textbox. They are unable to do so. They can copy the when but they try a right click or CTRL + V nothing happens

    I've looked at the text box properties and don't see anything that is preventing this.

    The data they are copying is Arial 10. The Textbox is formatted as Arial Regular 10.

    Is there something on the form or frame that is preventing the paste feature from not working.

    Thanks for the help..........

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: Excel 2010 Cannot paste into a form textbox

    If Locked property = False then no entry would be possible. Font style does not paste. The Font property in it governs so it is like PasteSpecial as plain text

  3. #3
    Registered User
    Join Date
    07-26-2017
    Location
    St. Louis, MO
    MS-Off Ver
    2010
    Posts
    8

    Re: Excel 2010 Cannot paste into a form textbox

    Locked = false. I changed it to True and was unable to enter anything in the TextBox. Once I changed it back to False, I could at least key data in the textbox. Thanks..

  4. #4
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: Excel 2010 Cannot paste into a form textbox

    Of course. It was the only reason I could think of. Something else may have cleared the clipboard. Shift+Insert can sometimes work but I suspect that something else is going on for that user.

    If you can duplicate the problem, you can post the workbook as an attachment.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel VBA form - textbox to export data over 255 characters from textbox
    By DannyJ in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-21-2017, 05:52 AM
  2. [SOLVED] Excel 2010 - Userform - display date from textbox in a label or textbox in 'ddd' format
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2015, 10:54 PM
  3. Excel 2010 – VBA Userforms – Vlookup via Textbox, display result in another textbox
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-29-2015, 12:31 AM
  4. 2010 Word form fields populated with 2010 Excel data
    By pballard66 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-23-2014, 11:55 AM
  5. Importing data from an Excel 2010 worksheet into a Word 2010 form.
    By Kuriakos in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-27-2012, 02:49 PM
  6. Replies: 0
    Last Post: 07-29-2011, 07:19 AM
  7. Copy cell data and paste it into textbox on form
    By jpruffle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-03-2009, 09:33 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1