Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding controls to a userform at runtime
I would like to generate various controls on a skeleton userform (eg, the
number may vary with the occasion) and have tried Private Sub UserForm_activate() Stop Dim obj As Object Set obj = Me Set obj = obj.Add("MSForms.CommandButton.1", "Butt1", True) but when the form opens I receive the error message Runtime error '-2147221005(800401f3': Invalid class string What am I doing wrong, please? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with adding Controls and event handlers at runtime | Excel Programming | |||
Need help with adding Controls and event handlers at runtime | Excel Programming | |||
Adding controls to a form at runtime | Excel Programming | |||
adding controls to userform at runtime | Excel Programming | |||
Userform runtime controls & Macs | Excel Programming |