MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Problems in writing VBA code for an ActiveX control

  Asked By: Dai    Date: Dec 23    Category: MS Office    Views: 1296

Using Excel 2002 I chose an ActiveX control (namely Microsoft Forms
2.0 Frame control) from Visual Basic Toolbar, Control Toolbox, More
Controls. This control is a UserForm which can be inserted in the
Worksheet. In its edit mode this frame control disposes of an own
toolbox with all the controls which can be added on it. After I built
the UserForm in this way, I couldn't write the necessary VB code
because in the window code object list box only frame shows but not
its controls (commandbutton, combobox, etc.).
What am I supposed to do so that in the window code show the controls
added on the frame as well?



1 Answer Found

Answer #1    Answered By: Vilmos Fischer     Answered On: Dec 23

I didn't try exactly what you're describing, but usually if you
click on the frame, then the object list will show the contained
controls. But that's usually the key -- you have to select the frame.

Didn't find what you were looking for? Find more on Problems in writing VBA code for an ActiveX control Or get search suggestion and latest updates.