Keep It Simple, Stupid | |
PerlMonks |
Re: Excel VB Controlsby Unanimous Monk (Sexton) |
on May 03, 2006 at 03:39 UTC ( [id://547049]=note: print w/replies, xml ) | Need Help?? |
You'll want to check out the "Shapes" method in the Worksheet object using Marto's Where do I find documentation for the object models? reference. Each form control is a "Shape", and its values can be manipulated through the OLEFormat object. The following sample code should put you on the right track. It will create a worksheet with a check box, check it, and then uncheck it. (If you're using something other than Excel 2003, you'll need to update the "Microsoft Excel 11.0 Object Library" to the correct version)
In Section
Seekers of Perl Wisdom
|
|