diference between FORMS & CONTROLS

M

Marek

people,

when i want to work with visual components placed on the worksheet, i
use FORMS toolbar

for example when i want to display value from combobox then i must
use Drawingobjects or Dropdowns collection

msgbox worksheets(1).dropdowns("combobox_number1").value



but when i use CONTROL toolbar
then i simply normally can do this

msgbox worksheets(1).combobox_number1.value


where is difference between this two TOOLBARS ???


visually they are similar
 
B

Bob Phillips

Marek,

Forms controls are simpler and easier to use when you are starting out, but
Control toolbox controls are far more flexible, and far more useful (IMO),

Control toolbox controls have far more properties associated with them that
can be set at design time, or in VBA, such as BackColor, etc. In addition
you can add an item to a controls toolbox in VBA, you cannot with Forms, you
can only link to a worksheet range,

All in all, I never use Forms controls because of the lack of flexibility,
but beware that control toolbox controls are not straightforward to use in
code, because of the OLEObject container.
 
Top