Friday, 15 June 2012

how to link a checkbox on Excel to a VBA code -


I have created a checkbox on my Excel worksheet using a design mode I have left it and named it ChkV , And I've written a VBA code but when I run it I get this message that the variable is not defined. 

  If ChkV.Value = true then 'My code and if   
 did not have I labeled the check box correctly, what am I doing Am wrong? How should I make a mistake?   
 
 
 this should not be  
  if activesheet.Checkboxes ("ChkV ") = XlOn 'if your code end if   
?   

 








Posted by



at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)