Control Toolbox Objects (XL97;SR2)

Topic

New Reply

Can someone provide a resouce for changing the properties of an object created with the Control Toolbox (View/Toolbars/Control Toolbox) through VBA. I know how to do it with a form(View/Toolbars/Forms) but this is a new challenge.

Thanks,
John

Reply | Quote

Replies

If you select the properties from the right-click menu for the object you can see the names of the properties

In VB use the name of the object a period and the property name eg:
activesheet.listbox1.height = 55
Steve

Reply | Quote

John,

A resource: XL VBA help – “Using ActiveX Controls on Sheets”

Jim Cone
San Jose, CA

Reply | Quote