+ Reply to Thread
Results 1 to 2 of 2

input text instead of copy and pasting

  1. #1
    Registered User
    Join Date
    02-19-2015
    Location
    Newcastle, England
    MS-Off Ver
    2013
    Posts
    98

    input text instead of copy and pasting

    hi

    is it possible to set up cells so someone has to type text into it rather than copy and paste from another cell and lose formatting?

    Thanks,

    Ben

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: input text instead of copy and pasting

    Put this code in the worksheet module:
    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ 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. Copy and pasting a range using autofilter and input box
    By sx200n in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2015, 08:42 AM
  2. Copy & pasting Trimmed text?
    By JoshJ in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-16-2014, 01:42 PM
  3. Copy from PDF and pasting to text file without using Sendkeys()
    By pledbetter in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-31-2013, 09:15 PM
  4. [SOLVED] In copy/pasting cells to a new sheet cannot automate cells (1, x) based on user input
    By CEDarnell in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-05-2012, 06:08 PM
  5. VBA code to copy data from text box and input into a cell in another worksheet
    By bobaftt in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-29-2011, 01:49 AM
  6. Copy and Pasting a cell but adding text
    By smokeydawson555 in forum Excel General
    Replies: 2
    Last Post: 09-03-2009, 01:07 AM
  7. Copy/Pasting a large ammount of text
    By Sordini in forum Excel General
    Replies: 7
    Last Post: 09-02-2009, 01:28 PM

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