Command Button properties from VBA

[DerbyDesign]

I want to insert command button using VBA. That’s the easy part. I tried to record macro while changing command button properties but the macro recorded nothing (except “select”). How can I change command button properties (e.g. PritnObject, Shadow, ForeColor, etc) using VBA?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Thanks,
<o> </o>
-dd

 

[EducatedFool]

Hi
Welcome to the Board

Look at this:
http://www.mrexcel.com/forum/showpost.php?p=1982863&postcount=2

 

[DerbyDesign]

Thanks EducatedFool. I searched the forum but somehow I missed the post you referred to. It is a bit complex (for me) but definitely helpful. At lease I know that the properties for Command Button can be set from VBA.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
-dd