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


---
Message posted from http://www.ExcelForum.com/

Here's a quick explanation:

http://tinyurl.com/7yqgz

HTH
Jason
Atlanta, GA

-----Original Message-----
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


---
Message posted from http://www.ExcelForum.com/

.

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.

--

HTH

RP

"Marek " wrote in message
...
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


---
Message posted from http://www.ExcelForum.com/

thanks you all people for your links and repl

--
Message posted from http://www.ExcelForum.com