I have made a ActiveX control which consists of some textboxes and a button.
Now I am trying to use this control in Excel, with the help of macros.
I have used ActiveSheet.OLEObject.Add to
add this control to Excel sheet,
though Control appears on the sheet but it is not responding.
There is no effect of clicking on the button.
if I click on Design mode button on Control toolbox toolbar and Exit the
design mode by clicking on the same button, The Control starts responding to
the button clicks.
I want my control to be added dynamically and should respond as it is drawn
on the sheet.
1. Am I Missing some thing that i need to do with OLEObject.Add, so that i
can use my control without clicking on the Design mode button.
2. Somebody can please tell how can i switch to and from design mode
Can somebody please help...