Difference between Form Control Object and Control toolbar Objects

[sabascal]

Hi
1)I'd like to understand what is the difference between a Combo Box:
i) I drag and drop form the form toolbar

ii) I drag and drop from the COntrol Toolbar

2) I would like to know how to reference them
i) For the form combobox
combobox_name.value return it's vlue
ii) how does it work for the control toolbar combobox

Thanks

 

[SkipVought]

sabascal,

The controls from the Forms toolbar have far fewer properties that you can control via VBA compared to controls from the Toolbox.

Here's how to "Discover" the differences.

1. Put one of each on your sheet.

2. activate the VB Editor and insert a sub stub

Sub test()

End Sub

3. using the debug toolbar, step into the sub

4. open the Watch Window and add the object, Activesheet

5. "open" ActiveSheet and observe the embedded objects -- properties, drill down etc.



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[RobBroekhuis]

To access the value of the control toolbox object, go through the OLEObjects collection, e.g.:

ComboSelection = activesheet.OLEObjects(1).object.value



Rob