Thread: copy checkbox string and paste it in excel sheet
View Single Post
 
Old 10-25-2015, 11:04 PM
MOHAMMEDSALMAN MOHAMMEDSALMAN is offline Windows 7 64bit Office 2007
Novice
  
Join Date: Sep 2015
Location: Mumbai
Posts: 9
MOHAMMEDSALMAN is on a distinguished road
Default copy checkbox string and paste it in excel sheet
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.
Reply With Quote