MrExcel Publishing
Your One Stop for Excel Tips & Solutions

generate an ActiveX control

Posted by Geoff on May 24, 2000 11:10 AM

Using VBA, what is the syntax to dynamically generate an ActiveX control on an Excel sheet, and in a certain location on the sheet also? For example, a user clicks a button on sheet1, I want to pull up sheet2 and generate a checkbox on it and then delete it when they are done with sheet2. Thanks for any help.

Posted by Geoff on May 24, 2000 12:08 PM


I figured it out