+ Reply to Thread
Results 1 to 4 of 4

Copy the value from a combo box and paste to a cell on another sheet.

  1. 01-13-2019, 12:44 AM #1
    chelsea7A
    chelsea7A is offline
    Registered User
    Join Date
    05-13-2016
    Location
    Richmond, NY
    MS-Off Ver
    2010
    Posts
    16

    Copy the value from a combo box and paste to a cell on another sheet.

    Good day,

    I'm trying to copy the value from a combo box and paste to a cell on another sheet. The code below works as long as the active cell is on the same sheet. Just copy and paste, no linking.

    Please Login or Register  to view this content.

    Thanks,
    Chelsea
    Reply With QuoteRegister To Reply
  2. 01-13-2019, 01:51 AM #2
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Copy the value from a combo box and paste to a cell on another sheet.

    Suppose you will copy the value of ComboBox1 to sheet named "Data" so you can refer to the sheet name then to the desired cell where you would like to put the value
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here
    Reply With QuoteRegister To Reply
  3. 01-13-2019, 09:11 PM #3
    chelsea7A
    chelsea7A is offline
    Registered User
    Join Date
    05-13-2016
    Location
    Richmond, NY
    MS-Off Ver
    2010
    Posts
    16

    Re: Copy the value from a combo box and paste to a cell on another sheet.

    Thanks that's exactly what I wanted it to do. Thanks a million!
    Reply With QuoteRegister To Reply
  4. 01-14-2019, 12:22 AM #4
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Copy the value from a combo box and paste to a cell on another sheet.

    You're welcome. Glad to help
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Combo-box (activex) copy paste value into combo-box
    By exceliousss in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-13-2018, 08:23 AM
  2. Search sheets for cell containing a word, copy paste row(s) to sheet 1, copy sheet name
    By jmemiller in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 08-02-2018, 10:54 PM
  3. Copy and paste combo box with relative Cell Link (Form Controls)
    By vpipalia in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-28-2017, 04:40 AM
  4. Copy and paste combo box with relative Cell Link
    By waheed254 in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 04-27-2017, 10:25 AM
  5. [SOLVED] Copy paste data one to multiple sheet based on cell value to sheet name
    By kannan1847 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-15-2015, 12:54 AM
  6. Copy Cell Range From Previous Sheet and Paste to Active Sheet
    By jtal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-01-2013, 03:26 PM
  7. Macro to update database, Match Cell value from Sheet 1 in Sheet 2 then copy and paste
    By Zawoooo in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-03-2012, 03:10 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1