+ Reply to Thread
Results 1 to 1 of 1

Checkbox Copy and Paste info only when checked to another cell

  1. #1
    Registered User
    Join Date
    06-13-2018
    Location
    Glasgow
    MS-Off Ver
    2013
    Posts
    33

    Checkbox Copy and Paste info only when checked to another cell

    I am looking to create a template with a combination of drop down options, checkbox and free format text. I am looking for the selected/input information to another cell. However, I am having trouble with the VBA (It's all new to me). I have attach the Excel document below.

    In short, I am looking for the information from cells E12 and E13 to copy to cell C30 but only when the checkbox is clicked. I need similar function for the other checkboxes but once I sort one I can use the same function and amend the target cells.

    The Generate Alert button will used to display and copy the finalised information. I have used simple formulas to copy this info so far but I am struggling with the VBA for the checkboxes. Any help will be greatly appreciated.
    Attached Files Attached Files

+ 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] Copy/paste data using checkbox-clear when unchckd & multiple selections paste in next cell
    By Staceymcw in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-02-2015, 12:09 AM
  2. [SOLVED] Want to shade cell when checkbox is checked
    By oneuglydude in forum Excel General
    Replies: 2
    Last Post: 01-02-2015, 08:13 AM
  3. If checkbox checked, cut row and paste on next sheet
    By BlueEyedLady in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-10-2014, 02:46 PM
  4. [SOLVED] When checkbox is checked it does not copy to new sheet. Only if not checked using false
    By thelisa in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-28-2013, 07:59 AM
  5. Copy values if checkbox is checked
    By jtone32512 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-21-2012, 03:54 AM
  6. Copy row data for checked checkbox
    By Christeen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-09-2011, 09:50 PM
  7. [SOLVED] copy if checkbox checked to sheet two
    By BillyRogers in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2006, 04:35 PM

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