Copy a Cell to Clipboard Using Checkbox

**nupema** · 01-19-2015, 12:59 PM

Hi,

Currently I have this VBA code working perfectly:

Sub clearcheck()
Dim sh As Worksheet
For Each sh In Sheets
On Error Resume Next
sh.CheckBoxes.Value = False
On Error GoTo 0
Next sh
Range("E2, F2").ClearContents
End Sub

I also have 3 checkboxes (form control) linked to 3 corresponding cells and I’m just using with some conditional format function to highlight 3 other cells “=IF($B10=TRUE;TRUE;FALSE)”.

Everything is working just fine, but now I would like to add one more function. What I need is that every time I tick a checkbox I need to automatically copy the content of another cell.

Example:

IF Cell B6 true, copy F6 content to clipboard.
IF Cell B8 true, copy F8 content to clipboard.
IF Cell B10 true, copy F10 content to clipboard.

Can anyone please help me.. 

**pjwhitfield** · 01-19-2015, 01:11 PM

You're better off doing the copy within the Checkbox_Click event, the following will copy F6 whenever the checkbox1 is ticked.

Please Login or Register  to view this content.

Dont forget however that clicking Box 1 and then Box2 will result in the clipboard holding Box2 value only.

**nupema** · 01-20-2015, 04:44 AM

Good morning to all,

pjwhitfield, first of all thank you for your quick reply.

I didn't figure it out why, but nothing happen using with your code.

However, right now its working using this code:

Please Login or Register  to view this content.

The only thing I need now and I can't get it to work yet is to clear the clipboard every time I untick a box.

If I use:

Please Login or Register  to view this content.

The code stop working in CheckBox1 and CheckBox2

Copy a Cell to Clipboard Using Checkbox

LinkBack

Thread Tools

Rate This Thread

Display

Copy a Cell to Clipboard Using Checkbox

Re: Copy a Cell to Clipboard Using Checkbox

Re: Copy a Cell to Clipboard Using Checkbox

Thread Information

Users Browsing this Thread

Similar Threads

Copy cell value to clipboard

[SOLVED] Copy text to clipboard based on CheckBox value on Command Button click

Find Cell Value and Copy to ClipBoard

Copy one cell to an other but colors do not copy. While not using clipboard to copy.

Copy content of cell to clipboard

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions