copy checkbox string and paste it in excel sheet

MOHAMMEDSALMAN · #1 10-25-2015, 11:04 PM

Hi Everyone,

I have checkboxes on vba form and a Sheet as "Sheet3". What I want is, when the user checks any of the checkbox on form I want to copy that string and paste it in column A of Sheet3 and column B should be marked as "X"
I am using the below code but it fails

Code:

For Each ctl In frmEqpDetails.MultiPage1.Pages(0).Controls
    If ctl.Value = True Then
    Sheets("Testing_Sheet").Find(test_info(eqp_count - 1).vis_tests(looper), LookIn:=xlValues) = "X"
    End If
    looper = looper + 1
Next

Please advise.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel copy two numbers between specific column and paste in next sheet	visha_1984	Excel	1	12-26-2014 07:59 PM
Want to change Macro to copy and paste data to new sheet	Vortex69	Excel Programming	0	12-23-2014 09:53 PM
Find Results in excel copy the rows to another sheet	khalidfazeli	Excel	2	02-06-2013 09:38 AM
How to Copy data from Outlook mail and Paste it in a Excel sheet?	padhu1989	Outlook	0	09-11-2012 04:07 AM
Word - Calculate and paste values from Excel sheet	Augf87	Word	1	07-06-2009 10:26 AM