Adding new ActiveX controls

UserForms can use other ActiveX controls developed by Microsoft or other vendors. To add an additional ActiveX control to the Toolbox, right-click the Toolbox and select Additional Controls. This will display the dialog box shown in Figure 13-15.

Additional Controls

&

Avelab'f CaohDls:

n MeltSkMflOClui

A

OK

j

□ Mbntnft Agent tartio) 2.0

Q MiciiosdH Anirstion Conlral tO (£P4|

Catei

|

□ ^ciosotl Corwnon C'sloc CciM. vnfEHn-S

□ MiamiA Caofiiir CnrKiol. ^t^skir. fi 0

r ii

G a-J" me Pick« Cori-olt 6 I

□ MciowH CrrsclAn raatkr. Comiol

O Munowll DrcclAn maicr, Pjih

G MeiOsOH OreclAfiifljIkri SoQuCnCS

□ "Hici^sifl EJfffctAniratior. SpnLe

□ Munosoll flreclAn racier, Slructned Qiapti"

stnw

□ MeiOitf D(eelAnnij(KnWp(JJi.veiflCirtlro k 1 u >

-

fl Selected Items On|y

tficiosoft Date ard Tim» Pete Cdt(ioI &.0|£F4|

Location C \WIND(^\Sys!e«ii3a,ims«mSi3 <**

Figure 13-15: The Additional Controls dialog box lets you add other ActiveX controls.

Figure 13-15: The Additional Controls dialog box lets you add other ActiveX controls.

The Additional Controls dialog box lists all ActiveX controls that are installed on your system. Select the control(s) that you want to add and then click OK to add an icon for each selected control.

Caution Not all ActiveX controls that are installed on your system will work in Excel UserForms. In fact, most of them probably won't work. Also, some controls require a license in order to use them in an application. If you (or the users of your application) aren't licensed to use a particular control, an error will occur.

NEXT

0 0

Post a comment